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!

Last 6 Months

sliderrulesDec 7 2010 — edited Dec 7 2010

Hi,

I am querying some data and would like to query the last 3 months and last 6 months. The date field is active_date(DD-MON-YYYY)

Can anyone recommend the best way to calculate the last 3/6 months?

Thanks

This post has been answered by Centinul on Dec 7 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 4 2011

Added on Dec 7 2010

3 comments

5,332 views