Oracle Database Express Edition (XE)

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!

Round Date to nearest Week Day

587355Jan 7 2008 — edited Jan 9 2008

I need to do a date calculation that will round a given date to the nearest weekday. For example, if the date is a Saturday, round to Friday; if it is a Sunday, round to Monday. Then, I need to also skip holidays. So, if the date turns out to be, say, Labor Day, round to Tuesday after Labor Day.

Does anyone know how to do this (short of coding for each and every holiday)?

Thanks!

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 6 2008

Added on Jan 7 2008

2 comments

680 views