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 vote299 views1 answer
Synapse sql table set pk
SQL
0 vote303 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
1 vote251 views1 answer
Mysqldump: couldn't execute 'select column_name,
SQL
4 votes330 views2 answers
Oracle drop job
SQL
0 vote295 views1 answer
Search In the Data using ObjectName
SQL
5 votes307 views1 answer
Oracle list functions
SQL
0 vote298 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
3 votes334 views4 answers
Postgresql change timezone on timestamp without timezone
SQL
0 vote305 views1 answer
6)selects only the DISTINCT values from the "side" column in the "Reserves" table
SQL
0 vote310 views3 answers
Delete in SQL SERVER
SQL