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

5 votes305 views1 answer
Ignore duplicate rows in sqlite
SQL
1 vote307 views1 answer
Pv mysql import
SQL
3 votes380 views1 answer
Oracle list invalid password logon denied
SQL
1 vote320 views1 answer
Regular expression in sql server
SQL
0 vote276 views1 answer
Mysql timeout 30 seconds
SQL
0 vote417 views1 answer
Php insert null mysql
SQL
31 votes305 views1 answer
Postgresql add column with constraint
SQL
0 vote303 views1 answer
How to get initials in sql
SQL
1 vote322 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote317 views1 answer
Edit shchima table in sql
SQL