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 vote217 views2 answers
Enter into postgresql database,create user and grant Access
SQL
1 vote212 views2 answers
Begin transaction sql
SQL
0 vote260 views1 answer
Postgres rename database
SQL
6 votes212 views2 answers
Postgresql pg_dump
SQL
0 vote200 views1 answer
Mysql average from two table
SQL
3 votes265 views2 answers
Oracle privileges users
SQL
-1 vote255 views3 answers
Error: mysql shutdown unexpectedly.
SQL
0 vote205 views3 answers
Magento 2 order delete from db
SQL
0 vote210 views1 answer
Postgresql linux password
SQL
0 vote256 views3 answers
Classement rang mysql 7
SQL