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

2 votes242 views2 answers
Mysql find max value row
SQL
0 vote240 views1 answer
Sql composite key
SQL
13 votes237 views5 answers
Select last row mysql
SQL
0 vote237 views1 answer
What is default mysql database password in linux
SQL
0 vote249 views1 answer
How to connect to xampp sql server on windows cmd
SQL
7 votes219 views2 answers
Create index mysql
SQL
5 votes216 views3 answers
How to remove unique key constraint in mysql
SQL
2 votes247 views3 answers
Sql function
SQL
0 vote243 views1 answer
Get who is hired in month in sql
SQL
2 votes257 views1 answer
Pdo mysql insert
SQL