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

24 votes94 views5 answers
Sql server insert into select
SQL
0 vote99 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote88 views1 answer
Dump multiple tables mysql
SQL
1 vote90 views1 answer
Sqlite check if row exists
SQL
23 votes101 views3 answers
Sql where contains part of string
SQL
1 vote97 views1 answer
Postgresql transaction discard all
SQL
1 vote86 views1 answer
T-SQL Alter the column data type
SQL
19 votes91 views4 answers
Rename database in sql
SQL
0 vote92 views1 answer
Sql server count all tables rows
SQL
6 votes99 views6 answers
Code: 'ER_NOT_SUPPORTED_AUTH_MODE', errno: 1251, sqlMessage: 'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004', fatal: true
SQL