28 May 2008

Oracle SQL : Work Days- Between Dates

If you want to find Working Days between two DATES here is the SQL statement

select count(1) from (select :from_date + rownum -1 Datex from dba_objects
where :to_date > :from_date + rownum -2)
where to_char(datex,'D') not in ('1','7')

No comments: