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

1 vote321 views1 answer
Xampp import sql file command line
SQL
3 votes324 views3 answers
Cannot truncate a table referenced in a foreign key constraint
SQL
0 vote316 views1 answer
Oracle show running job
SQL
4 votes309 views2 answers
Sql vs mysql
SQL
11 votes318 views2 answers
Having in sql
SQL
0 vote318 views1 answer
Char vs varchar2 in sql
SQL
2 votes391 views1 answer
Tcl in sql
SQL
15 votes306 views2 answers
How to drop database name in postgresql
SQL
3 votes319 views1 answer
Sql server check version
SQL
28 votes372 views6 answers
Sql update
SQL