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 views1 answer
Sql tablo hangi sp de
SQL
5 votes160 views2 answers
Oracle find all tables with column name
SQL
0 vote145 views1 answer
How to stop all connections to a psql 12 database?
SQL
0 vote150 views1 answer
Sql server whoami
SQL
2 votes156 views3 answers
How to check current user in mySQL
SQL
25 votes152 views1 answer
Mysql grant all privileges to a user
SQL
10 votes142 views2 answers
Sql merge statement
SQL
2 votes158 views1 answer
Metasploit start postgresql
SQL
3 votes187 views2 answers
Find string in stored procedure sql server
SQL
0 vote140 views1 answer
Oracle DROP PROGRAM
SQL