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 votes175 views2 answers
Convert_tz mysql
SQL
0 vote153 views1 answer
Get the previous column of a table in mysql
SQL
4 votes158 views4 answers
Check constraint in ms sql
SQL
0 vote157 views1 answer
Select place default lat long
SQL
0 vote221 views1 answer
Contraint default SQL
SQL
0 vote144 views1 answer
Python mysql query where
SQL
1 vote180 views1 answer
Varchar plsql
SQL
0 vote258 views1 answer
Como verificar registros duplicados no sql postgresql
SQL
0 vote158 views1 answer
Column ' ' in field list is ambiguous
SQL
0 vote137 views1 answer
Mysql database is not starting in xampp
SQL