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 vote190 views1 answer
Sql change date format
SQL
0 vote207 views1 answer
Mysql get last 2 month data
SQL
0 vote204 views1 answer
Jdbc sql connection string
SQL
3 votes194 views1 answer
MySQL DELETE JOIN
SQL
1 vote204 views1 answer
Psql lst trigger
SQL
20 votes210 views6 answers
Change password in mysql
SQL
0 vote277 views2 answers
Mysql insert rows to another database
SQL
0 vote196 views1 answer
Psql datestyle
SQL
11 votes190 views4 answers
Query DISTINCT
SQL
44 votes253 views4 answers
Mysql alter table add column first
SQL