select sum(work_day)+1 Work_day_of_mon from
(select to_char(sysdate-to_char(sysdate,'DD')+level,'D'),
case to_char(sysdate-to_char(sysdate,'DD')+level,'D')
when '1' then 1
when '2' then 1
when '3' then 1
when '4' then 1
when '5' then 1
when '6' then 0
when '7' then 0
end as work_day from dual connect by level<to_char(sysdate,'DD'))
抛块苯砖先!
|