SELECT <columns>
FROM <table>
WHERE <date_column> >= ADD_MONTHS(SYSDATE,-36)
;

-----Original Message-----
From: Alan Vervaeke
[mailto:oracledba-ezmlmshield-x93019633.[Email address protected]
Sent: Thursday, September 27, 2007 1:34 PM
To: LazyDBA Discussion
Subject: current date minus exactly 3 years

Sorry, but I am experiencing intra-cranial flatulence.



A simple query to select records where record date is greater than or
equal to sysdate minus 3 years??



Anyone? Bueller ?? Bueller ??



Alan





---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page