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 votes145 views2 answers
Search text in all sql server stored procedure
SQL
0 vote266 views2 answers
Create new table from existing table with data in sql server
SQL
1 vote138 views1 answer
Select random sample sql
SQL
3 votes150 views2 answers
Mysql import gz
SQL
23 votes139 views6 answers
Create table sql server
SQL
0 vote132 views1 answer
How to select only a certain date sql
SQL
0 vote144 views1 answer
Sql cnvert bit to nvarchar
SQL
7 votes101 views1 answer
Alter table add key sql
SQL
0 vote133 views1 answer
Postgresql regular expression special characters
SQL
2 votes133 views1 answer
Change primary key sql
SQL