How to find the difference between two dates omitting weekends and holidays?

Interview Candidate
Oct 22nd, 2007
1
4323

First
Prev
Next
Last

Showing Answers 1 - 1 of 1 Answers

vanigreat
Profile Answers by vanigreat

Jan 17th, 2008

select (to_date('31/01/2008','dd/mm/rrrr')-to_date('01/01/2008','dd/mm/rrrr')+1) -
(select count(days) from (select
to_char(to_date('01/01/2008','dd/mm/rrrr')+level,'D') days
from dual connect by level <=31) where
days in ('7','1')) day from dual