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!

Calculate first business day of a month.

SudheerkumarvangalaDec 3 2010 — edited Dec 6 2010

Hi All,

I need to calculate first business day of a month. (Excludes sat, sun and holidays). I have a list of holidays in a table.

Could anyone please tell me how toget started..??

Let’s say I have a table xx_activity where I have all the month begin dates.

01-JAN-10
01-FEB-10 and so on

Now I need to bring 1st business day of each month. For 01-JAN-10, 1st business day is 04-JAN-10.

TIA..

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 3 2011

Added on Dec 3 2010

#date

5 comments

5,674 views