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

18 votes341 views3 answers
Mysql add column with default value
SQL
4 votes349 views2 answers
Sql offset
SQL
1 vote323 views1 answer
Alter table column size oracle
SQL
12 votes325 views4 answers
Install mysql ubuntu 18.04
SQL
2 votes344 views1 answer
Update with join sql server
SQL
5 votes312 views2 answers
Oracle to_timestamp
SQL
1 vote329 views2 answers
Last working day in week date function in sql
SQL
-1 vote354 views1 answer
How to change the auto increment in existing table mysql
SQL
1 vote351 views1 answer
Mysql strict_trans_tables
SQL
1 vote352 views1 answer
Group_concat max length mysql
SQL