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 vote102 views1 answer
Oracle sql winter time change
SQL
0 vote101 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote108 views1 answer
Normalization in database 2nd normal form
SQL
0 vote115 views1 answer
Psql check if sql script is valid
SQL
0 vote111 views1 answer
Oracle exchange partition
SQL
1 vote97 views1 answer
How to open closed port mysql in ubuntu
SQL
6 votes93 views2 answers
Find mysql version linux
SQL
4 votes60 views2 answers
Select todays data postgres query
SQL
0 vote104 views1 answer
Get week day name sql server
SQL
0 vote105 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL