About Me

Sree Kalyan chakravorty
View my complete profile

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

Posted by kalyan at 5:52 PM  

Labels:

0 comments:

Post a Comment

Newer Post Older Post Home

Subscribe to: Post Comments (Atom)