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!

Date Function 'ADD_WEEKS' ??

4698Feb 4 2002

I am in need of Date Function 'ADD_WEEKS'
similar what 'ADD_MONTHS' date function can do.

I know the 'No of Weeks' I need to turn back the Clock. 4 or 5 weeks.

I cannot use ADD_MONTHS function because it exactly turns back 1 month.

any ideas ?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 4 2002

Added on Feb 4 2002

2 comments

6,476 views