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

Remove ugly bash (shell) directory highlight colors

Tired of green over blue colors in default Ubuntu shell for directories ? Just type this from your shell console to update your bash profi...