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

6 votes65 views2 answers
Spring data jpa application.properties mysql
SQL
0 vote100 views1 answer
Pgadmin see indexes
SQL
0 vote152 views1 answer
Oracle temporary table
SQL
2 votes113 views2 answers
How to rename column name in sql server using query
SQL
2 votes114 views1 answer
Oracle kill session by sql_id
SQL
0 vote117 views1 answer
Php get closest location by latitude longitude
SQL
0 vote113 views1 answer
SQL get max per id
SQL
0 vote112 views1 answer
Bidirectional outer join sql
SQL
4 votes112 views3 answers
How to describe a table in sqlite3
SQL
0 vote104 views1 answer
Mysql grant all on all databases
SQL