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.

Source : http://blog.jooq.org/2015/09/15/dont-format-dates-in-sql-use-the-date-literal/