Re: Working days

On 10 Apr 2003 09:56:13 -0700, mmontreaux_at_hotmail.com (Monty) wrote:

>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

Hi Monty,

This is one of about a dozen ways to do it :

select sysdate + (case when to_char(sysdate,'D') in ('1','2','7') then 3 when to_char(sysdate,'D') in ('3','4','5') then 5 else 4 end ) from dual;

If you are running 9i, you may also consider the EXTRACT date function.

• Kenneth Koenraadt