Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

select date +- 2 years

947561Aug 13 2012 — edited Aug 14 2012
Hi,

Please let me know how to select rows from table where date = sysdate + - 2 years
if sysdate is 13/08/2012 then select rows where date between 01/08/2010 to 01/08/2012

Note: I want just month and year to be +- 2 years and not the day part.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 11 2012
Added on Aug 13 2012
4 comments
2,112 views