Kalyan Chakravorty Blog: oracle sql timestamp

Showing posts with label oracle sql timestamp. Show all posts

Thursday, April 23, 2009

alter session set NLS_DATE_FORMAT='DD-MM-YYYY HH24:MI:SS'

select * from table where date > to_date('2009-04-01','yyyy-mm-dd');