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 vote279 views1 answer
Oracle procedure teamplate
SQL
0 vote309 views3 answers
Sql parenthetical expression examples
SQL
1 vote309 views1 answer
Postgres left join
SQL
8 votes277 views1 answer
How to remove tables from postgresql
SQL
0 vote270 views1 answer
View to table
SQL
2 votes305 views1 answer
Get the mysql table columns data type mysql
SQL
2 votes273 views1 answer
Mysql find tables with name
SQL
14 votes316 views5 answers
Set password for postgres user ubuntu
SQL
0 vote327 views1 answer
Install mysql on bash
SQL
2 votes301 views1 answer
Show max_allowed_packet mysql
SQL