Re: Oracle calendar teaser...
Date: Thu, 19 Nov 1998 23:22:09 +0400
Message-ID: <7329j4$6gc3_at_news1.emirates.net.ae>
Try this one ...
SELECT TO_NUMBER(LEAST(5,(6-TO_CHAR(TO_DATE('&&DAY1','DD/MM/RR'),'D'))+1)) +
TO_NUMBER(LEAST(5,TO_CHAR(TO_DATE('&&DAY2','DD/MM/RR'),'D')-1)) +
(
TO_DATE('&&DAY2','DD/MM/RR') -
TO_NUMBER((TO_CHAR(TO_DATE('&&DAY2','DD/MM/RR'),'D') - 1 ))
)
-
(
TO_DATE('&&DAY1','DD/MM/RR') + 1 +
TO_NUMBER(((6 - TO_CHAR(TO_DATE('&&DAY1','DD/MM/RR'),'D')) + 1))
)
)/7)*5) WORKING_DAYS
FROM DUAL;
Martin Anderson wrote in message <3651F391.304C13D5_at_bbn.com>...
>Hi folks,
>
>I have a little teaser for y'all. I want to write an SQL script (not
>PL/SQL) that will tell me how many weekdays (Mon-Fri) there are between
>2 dates. Can this be done and if so how?
>
>Thanks in advance.
>
>Martin
>
Received on Thu Nov 19 1998 - 20:22:09 CET