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!

How to get date for x numb. of days excluding weekends & starting sysdate+1

435184Jan 22 2009 — edited Jan 23 2009

Hi,

How can I find the date if I have number of days. e.g. if I want to know what is the date in next 6 days excluding today I can do the following here sysdate+1 is I don't want to include today and 7 is the number of days no this will include weekends also i.e. Saturday, Sunday

select sysdate+1+7 from dual
output: *29-Jan-2009 23:21:11*

Now wat will be the query to get the date for 7 business working days only excluding Saturday, Sunday. I want to get the date starting from sysdate+1 and including only business working days. i.e. 7 is the working business days. So if I don't include weekends I am expecting the following output: *03-Feb-2009 23:21:11*

Any help is appreciated.

Thanks

Edited by: guest0012 on Jan 22, 2009 8:28 PM

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 20 2009

Added on Jan 22 2009

4 comments

914 views