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 vote168 views1 answer
Oracle execute package dblink
SQL
57 votes1.4K views5 answers
How to create a new user in postgresql
SQL
2 votes141 views2 answers
How to check database username and password in postgresql
SQL
1 vote145 views1 answer
Sql delete all values in a column
SQL
0 vote185 views1 answer
SQL-Arten
SQL
1 vote164 views1 answer
Psql connect to another database
SQL
0 vote148 views1 answer
Initcap in mysql
SQL
0 vote170 views1 answer
Time in sql server
SQL
0 vote139 views1 answer
Postgresql find missing id
SQL
0 vote160 views1 answer
How to read the potentail error messages in ssis package
SQL