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

1 vote161 views1 answer
Psql search table
SQL
0 vote141 views1 answer
Linebreak sql
SQL
3 votes143 views4 answers
Show databases in sql server
SQL
1 vote131 views1 answer
How to delete a record from sqlite in android
SQL
17 votes142 views6 answers
Change column name in sql
SQL
1 vote130 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
23 votes144 views4 answers
How to uninstall postgresql in ubuntu
SQL
17 votes145 views3 answers
Postgresql version command
SQL
13 votes157 views2 answers
Sqlite rename table
SQL
6 votes144 views3 answers
Mysql create database utf8
SQL