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

Home -> Community -> Usenet -> c.d.o.server -> Working days

Working days

From: Monty <mmontreaux_at_hotmail.com>
Date: 10 Apr 2003 09:56:13 -0700
Message-ID: <6284dd3.0304100856.2f701c1a@posting.google.com>


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

Original text of this message

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