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 365 days from a value

584260May 20 2009 — edited May 25 2009

Hi,

I need to select last 365 days from the value returning from the below query
(SELECT MAX(MONTH_END_DT) FROM CONTROL.CTL_BATCH_CONTROL).

MONTH_END_DT - its a date column in table CTL_BATCH_CONTROL.

Can anyone help me in this plz.

Thanks
Radha K

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 22 2009

Added on May 20 2009

6 comments

1,474 views