query to get a date column is greater than a year
849776Apr 11 2011 — edited Apr 11 2011Hi all,
I had a table :
order date
1 4/4/2010 9:10:09 AM
2 5/6/2011 9:10:09 AM
my select statement should return a row which is more than a year
and date is timestamp(3) datatype (considering leap year to)
can any one help me
Thanks in advance!!!!
Edited by: 846773 on Apr 11, 2011 1:21 PM