Wednesday, May 25, 2011

How to calculate Number of working days in Current Month Using SQL

select count(*)
from(
select trunc(sysdate,'month')+rownum-1 dy
from all_objects
where rownum <= last_day(sysdate) - trunc(sysdate,'month')+1)
where to_char(dy,'fmday') not in ('sunday','saturday');
Until next post ... :)

No comments:

Post a Comment