oracle 查询当前年每月多少天和当前月有多少天（抛除双休日）

当前年每月有多少天

select to_char(d, 'mm') yue, sum(a) gongzuori
  from (select 1 a, trunc(sysdate, 'YY') + rownum - 1 as d
  from dba_objects
 where rownum <=
       TO_CHAR(LAST_DAY(ADD_MONTHS(trunc(sysdate, 'YY'), 11)), 'DDD')) where to_char(d, 'd') <> 1
   and to_char(d, 'd') <> 7
 group by to_char(d, 'mm')
 order by to_number(yue)

 

 

当前月有多少天

select count(d)
  from (select trunc(sysdate, 'mm') + rownum - 1 as d
          from dba_objects
         where rownum <=
               TO_CHAR(ADD_MONTHS(trunc(sysdate, 'mm'), 1) - 1, 'dd'))
 where to_char(d, 'd') <> 1
   and to_char(d, 'd') <> 7