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 vote226 views1 answer
Mysql if example
SQL
1 vote255 views1 answer
Create procedure with encryption
SQL
0 vote263 views1 answer
Exectuer myssql .sql
SQL
14 votes294 views5 answers
Set password for postgres user ubuntu
SQL
0 vote218 views1 answer
Deleted table in sql trigger
SQL
1 vote219 views2 answers
OSError: mysql_config not found mysql_config --version mariadb_config --version mysql_config --libs ---------------------------------------- ERROR: Command errored out with exit status 1: python setup.py egg_info Check the logs for full command outpu
SQL
1 vote275 views1 answer
What is a Database?
SQL
4 votes256 views2 answers
Sql table
SQL
3 votes273 views1 answer
Sql add two values together
SQL
5 votes246 views1 answer
Oracle asynchronous query
SQL