Oracle FAQ
|
Your Portal to the Oracle Knowledge Grid
|
Home ->
Community ->
Usenet ->
c.d.o.server ->
Date Arithmetic - Number of Work Days
Date Arithmetic - Number of Work Days
- Does anyone know how to calculate the number of work days between
two specified dates. Work days would, of course, exclude weekends and
statutory holidays. It seems like a simple problem until Good Friday
or situations like Christmas occuring on a Sat/Sun are considered.
- This functionality is required to determine if contractual lead
times are being met, so an accurate method is required.
- I am looking for something that could be coded in PL/SQL or an SQL
statement. If possible, I would like it to be maintenance free for the
next 5-10 years.
Received on Wed Dec 11 1996 - 00:00:00 CST
Original text of this message