Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Calculating the number of "working days" for a given period
-- 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# ================================================================= Andy Smith Email: andy.smith_at_citicorp.com Oracle Database Administrator Tel: 0171 500 5896 CITIBANK LondonReceived on Thu Mar 20 1997 - 00:00:00 CST