Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Working days
Hi, can someone help me with a SQL query to calculate the date which
is todays date+3 non-weekend days, ie monday 01 jan+3=thursday 04 jan,
tuesday 02 jan+3=friday 05 jan, wednesday 03 jan+3=monday 08 jan,
thursday 04 jan+3=tuesday 09 jan, friday 05 jan+3=wednesday 10 jan,
saturday 06+3=wednesday 10 jan, sunday+3=wednesday 10 jan.
Thank you
Monty
Received on Thu Apr 10 2003 - 11:56:13 CDT