To date oracle

To date oracle with time

-- TO_TIMESTAMP(date_string,'YYYY-MM-DD HH24:MI:SS')
SELECT TO_TIMESTAMP('2021-02-21 23:12:01','YYYY-MM-DD HH24:MI:SS') FROM DUAL;

To date oracle

SELECT TO_DATE('14/07/2021','DD/MM/YYYY') FROM DUAL;

                                  WATCH OUT! 
/*	  in the example before if you write '14072021' instead of '14/07/2021'
      you'll get the same result, if you want an exception to be thrown you    
      should add the prefix 'fx' (force) to the format, so that he will 
      match only the exact format. here's some examples:
         SELECT TO_DATE('14/07/2021','fxDD/MM/YYYY') FROM DUAL;--WORKS
         SELECT TO_DATE('14072021','DD/MM/YYYY') FROM DUAL;    --WORKS
         SELECT TO_DATE('14072021','fxDD/MM/YYYY') FROM DUAL;--EXCEPTION      */

Similar codes

2 votes234 views1 answer
Sql view column data type
SQL
0 vote300 views2 answers
Oracle create tablespace autoextend
SQL
0 vote306 views1 answer
How to find symmetric pairs in sql
SQL
-1 vote302 views1 answer
SQL SERVER microsoft How to Add Column at Specific Location in Table
SQL
6 votes311 views4 answers
Mysql group by date
SQL
0 vote298 views1 answer
Sql common columns
SQL
0 vote282 views1 answer
Cara menampilkan user di mysql terminal
SQL
0 vote293 views1 answer
Delete * from where id = 1;
SQL
5 votes303 views1 answer
Invalid column name sql
SQL
0 vote352 views1 answer
Oracle convert int to date
SQL