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 vote216 views1 answer
Space not removing from column in sql
SQL
24 votes189 views6 answers
Rename a column in sql server
SQL
0 vote195 views2 answers
Laravel: customize or extend notifications - database model
SQL
1 vote185 views1 answer
User privileges postgresql information_schema
SQL
0 vote211 views1 answer
Delete hangfire retries list
SQL
-1 vote236 views1 answer
How to Activate the database
SQL
20 votes190 views4 answers
Sqlite create table if not exists
SQL
0 vote204 views1 answer
What is database username and password in mysqliconnect
SQL
0 vote238 views1 answer
T-SQL Create Trigger
SQL
1 vote272 views2 answers
Sql example query
SQL