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 votes192 views1 answer
Async await mysql nodejs
SQL
0 vote199 views1 answer
Convert polygon to text in mysql
SQL
0 vote205 views2 answers
How to login to mysql as normal user in ubuntu
SQL
51 votes601 views6 answers
Installing mysql on ubuntu
SQL
0 vote195 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote202 views1 answer
Google cloud sql postgres url example
SQL
1 vote188 views1 answer
List all triggers in SQL Server
SQL
1 vote181 views1 answer
Mysql count words
SQL
1 vote135 views1 answer
Postgres division by zero
SQL
0 vote182 views1 answer
Check duplicate values plsql
SQL