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 vote377 views2 answers
How to get the date from datetime in mysql
SQL
0 vote362 views1 answer
T-SQL Never ending DELETE
SQL
4 votes378 views2 answers
Oracle unlock account
SQL
0 vote366 views1 answer
Sqlite explain plan
SQL
5 votes338 views2 answers
Mysql where in array
SQL
0 vote366 views1 answer
C# add a textbox in mysql select
SQL
3 votes348 views5 answers
Mysql get last inserted id
SQL
5 votes368 views2 answers
Mysql create database charset utf8mb4
SQL
1 vote354 views1 answer
Pv mysql import
SQL
11 votes379 views3 answers
Sql line numbers
SQL