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

0 vote337 views1 answer
Mariadb change column type
SQL
0 vote313 views2 answers
Start mysql server using docker
SQL
0 vote286 views1 answer
Tsql generate rows
SQL
0 vote273 views1 answer
Java mysql date format
SQL
0 vote240 views1 answer
Mysql offset from bottom
SQL
17 votes292 views3 answers
Postgresql version command
SQL
17 votes292 views2 answers
Mysql date to string
SQL
0 vote302 views1 answer
How to add boolean column in postgresql
SQL
0 vote304 views1 answer
Delete duplicate rows
SQL
13 votes321 views4 answers
Mysql remove foreign key constraint
SQL