Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Calculating "working days" for a given period

Calculating "working days" for a given period

From: Andy Smith <andy.smith_at_citicorp.com>
Date: 1997/03/20
Message-ID: <33311E44.6C87@citicorp.com>#1/1

-- 
Hi 

Need some help on this one.
Appreciate if anyone has a script that will calculate the number
of working days, given a starting and ending date.

Both starting and ending date is stored as a number of seconds since
1st June 1970.

e.g

TABLE
-----
Startdate	NUMBER(15)
Enddate		NUMBER(15)


Regards#



e.g 
=================================================================
Andy Smith			 Email:   andy.smith_at_citicorp.com
Oracle Database Administrator      Tel:   0171 500 5896
CITIBANK
London
Received on Thu Mar 20 1997 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US