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

13 votes280 views1 answer
Sql join 3 tables on id
SQL
1 vote294 views1 answer
How to get the date diff on once field in sql server
SQL
5 votes290 views3 answers
Show indexes mysql
SQL
3 votes282 views1 answer
Set default today mysql
SQL
2 votes255 views1 answer
Insert from table tsql
SQL
5 votes276 views1 answer
JBDC
SQL
0 vote263 views1 answer
Update set with inner join oracle
SQL
1 vote276 views1 answer
Sql server kill all connections
SQL
0 vote268 views1 answer
Add column in sql server ubuntu
SQL
0 vote287 views1 answer
Sql server Cost Fifo query
SQL