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!

Removing 2 years from date in where clause

jerry8989Mar 2 2012 — edited Mar 2 2012
I have a table that has a date and I want to select all the rows where the date is between the current date and 2 years back.

What is the cleanest way to do it?

I have the this so far
select TO_DATE(CURRENT_DATE, 'DD-MON-YYYY') from dual

Thank you
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 30 2012
Added on Mar 2 2012
#date
6 comments
2,799 views