Sunday, October 4, 2009

Derive Business Days Count

SELECT count(business_date) business_day
FROM (SELECT TO_DATE (:TO_DATE, 'DD-MON-YYYY')
+ ROWNUM
- 1 business_date
FROM all_objects
WHERE ROWNUM <=
TO_DATE (:FROM_DATE, 'DD-MON-YYYY')
- TO_DATE (:TO_DATE, 'DD-MON-YYYY')
+ 1)
WHERE TO_CHAR (business_date, 'DY') NOT IN ('SAT', 'SUN'

No comments:

Post a Comment

Blog Archive