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

0 vote186 views1 answer
Create table in dbms cmds
SQL
0 vote173 views1 answer
Update set with inner join oracle
SQL
0 vote224 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote169 views2 answers
Update information in a mysql column
SQL
1 vote261 views1 answer
Oracle previous year
SQL
1 vote183 views1 answer
Convert epoch to date in sql server
SQL
0 vote185 views1 answer
Find most frequent value in SQL column
SQL
-1 vote274 views1 answer
Brisanje dupliranih konatakata
SQL
0 vote169 views2 answers
Get top 1 row of each group
SQL
1 vote174 views1 answer
Trigger in postgresql to change incoming entry
SQL