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

5 votes337 views1 answer
How to check port number for postgresql
SQL
0 vote344 views1 answer
Add column to table with default value plsql
SQL
25 votes381 views4 answers
Sqlserver add column
SQL
1 vote373 views1 answer
Round one decimal place mysql
SQL
-1 vote357 views1 answer
Module operator in oracle sql
SQL
2 votes345 views3 answers
Postgresql reset auto increment
SQL
0 vote350 views1 answer
Narural join
SQL
1 vote348 views1 answer
Duplicating a MySQL table with all the data Command
SQL
10 votes375 views1 answer
Oracle view dependencies
SQL
2 votes369 views2 answers
Mysql count rows returned
SQL