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 vote174 views2 answers
Psql commande \gset
SQL
45 votes261 views5 answers
Grant all privileges mysql
SQL
1 vote176 views1 answer
Install postgresql on raspberry pi
SQL
0 vote182 views1 answer
Creating a simple notify in postgresql
SQL
0 vote167 views1 answer
How to drop columns with constraint from a table in sql script
SQL
0 vote177 views2 answers
Plan d'exécution requete oracle autotracer
SQL
1 vote357 views3 answers
Create table from existing table in sql
SQL
0 vote183 views1 answer
Mysql listing get a particu particular user firsdt
SQL
6 votes222 views1 answer
Postgresql get year
SQL
0 vote180 views1 answer
Mysql reset wp_options
SQL