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

7 votes282 views5 answers
Oracle alter table
SQL
0 vote256 views1 answer
Sql grant select only
SQL
0 vote238 views1 answer
Opensuse status MySQL
SQL
2 votes294 views1 answer
Create mysql user on all hosts
SQL
0 vote264 views1 answer
Sql contains vs like
SQL
1 vote244 views1 answer
Mysql find tables with column name
SQL
1 vote261 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
5 votes246 views6 answers
Sql add days to date
SQL
12 votes261 views2 answers
Delete entries in postgresql
SQL
21 votes255 views6 answers
Docker run mysql
SQL