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

3 votes126 views1 answer
Oracle list invalid password ORA-01017
SQL
6 votes171 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote124 views1 answer
Insufficient memory to excute the sql query
SQL
1 vote125 views1 answer
Mysql select row with max value group by
SQL
0 vote123 views1 answer
FIND most frequent word in sql server
SQL
1 vote150 views2 answers
Oracle 18c xe ORA-65096
SQL
25 votes123 views5 answers
Date in mysql
SQL
5 votes118 views3 answers
Sql max value in column
SQL
2 votes128 views1 answer
How to insert string variable into sqlite database
SQL
0 vote152 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL