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 vote319 views1 answer
Mysql get 2nd value in comma separated list
SQL
1 vote345 views1 answer
Expression number 1 of select list is not in group by clause
SQL
2 votes313 views1 answer
11:04:35 PM [mysql] Error: MySQL shutdown unexpectedly.
SQL
0 vote336 views1 answer
Sql count null values in all columns
SQL
0 vote313 views1 answer
Getting next sequence value jpa postgress
SQL
1 vote354 views1 answer
Table information in sql server
SQL
0 vote332 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote348 views1 answer
Postgresql replace html tags from string
SQL
1 vote344 views1 answer
Wordpress change http to https phpmyadmin
SQL
-1 vote360 views1 answer
Mysql faster insert
SQL