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 vote159 views1 answer
What is the essence of SQL?
SQL
0 vote162 views1 answer
Restart postgresql.service Failed to restart postgresql.service: Unit not found.
SQL
5 votes158 views1 answer
Oracle generate list of dates in between a date range
SQL
2 votes132 views1 answer
Sql float to int
SQL
0 vote159 views1 answer
Oracle drop default value
SQL
0 vote175 views2 answers
Update all columns in one update
SQL
0 vote187 views1 answer
Sql missing values
SQL
5 votes181 views4 answers
Change auto increment mysql
SQL
3 votes171 views2 answers
Postgres inner join vs join
SQL
0 vote176 views1 answer
On sql table data exists
SQL