Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Date Arithmetic - Number of Work Days
Gee, Ted, sounds like the kind of work I used to get paid for.
janet
Ted Goulden wrote:
>
> 1. 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.
>
> 2. This functionality is required to determine if contractual lead
> times are being met, so an accurate method is required.
>
> 3. 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