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

4 votes352 views1 answer
Sql any
SQL
1 vote335 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote378 views1 answer
How to use db.execute
SQL
1 vote386 views2 answers
Oracle difference between two dates in seconds
SQL
8 votes357 views2 answers
Oracle auto increment primary key
SQL
3 votes365 views4 answers
Order by desc postgres
SQL
1 vote340 views1 answer
List index mysql cli
SQL
0 vote354 views1 answer
Sql server get date of previous sunday
SQL
-1 vote370 views3 answers
How to restart mysql in linux
SQL
0 vote363 views1 answer
Oracle date winter time
SQL