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

9 votes220 views2 answers
Convert data type in sql
SQL
1 vote206 views2 answers
Mysql extract month
SQL
38 votes282 views6 answers
Ubuntu install mysql client
SQL
22 votes199 views4 answers
Mysql reset auto increment id
SQL
0 vote204 views1 answer
What is metadata in sql
SQL
28 votes300 views6 answers
Foreign key
SQL
0 vote303 views1 answer
Sql to search who modified
SQL
4 votes205 views4 answers
Rollback in sql
SQL
1 vote215 views1 answer
Add current timestamp in mysql
SQL
0 vote228 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL