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!

Return date excluding holidays and weekends

user10412263Sep 18 2014 — edited Oct 8 2018


Hello all,

I want to return a date which is n days after input date. It should not include any holidays and weekends.

e.g. If input date is 15 aug and n days = 15, then result date should be 8 sep.
[Considering 15 aug and 29 aug are holidays].

My oracle version is 11g.

Thanks in advance.
This post has been answered by BluShadow on Sep 19 2014
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 17 2014
Added on Sep 18 2014
11 comments
3,319 views