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 vote132 views1 answer
Jdbc sql connection string
SQL
1 vote135 views1 answer
Convert varchar to int in sqlite
SQL
2 votes146 views1 answer
Query to find table size in oracle 12c
SQL
0 vote164 views1 answer
Sql count matching group by
SQL
0 vote147 views1 answer
Sql field equals multiple values
SQL
1 vote164 views3 answers
How to update column name in psql
SQL
0 vote125 views1 answer
Create schema sql server
SQL
9 votes122 views3 answers
Where in sql
SQL
4 votes126 views1 answer
Sql query to make a existing column auto increment
SQL
0 vote135 views1 answer
Soql user profile
SQL