Thursday, April 23, 2009

Oracle setting timestamp format and query

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');

No comments: