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 vote182 views1 answer
Postgresql function ROUND
SQL
0 vote163 views1 answer
How to order result of subquery in select
SQL
5 votes158 views1 answer
Oracle scan source ddl
SQL
0 vote162 views1 answer
Postgre admin slow
SQL
0 vote182 views1 answer
Php select data from mysql database without column name
SQL
0 vote163 views1 answer
Groupby error in mysql
SQL
1 vote163 views1 answer
Partition by sql server
SQL
0 vote178 views1 answer
Sql update subtract value
SQL
0 vote174 views1 answer
Ajax error exception handeling
SQL
27 votes208 views6 answers
Sql update record
SQL