Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Calculating "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# e.g ================================================================= 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