Tuesday, September 22, 2015

No more to_date in Oracle SQL

You should prefer something like that :

SELECT
  DATE '2015-08-01' AS d,
  TIMESTAMP '2015-08-01 15:30:00' AS ts
FROM DUAL;


This is conform to ISO8601.


1 comment:

simashree said...

Thanks for the great information in your blog Selenium Training in Chennai