要求输入两日期参数,返回两个日期参数之间的工作日天数(工作日指除了周六和周日)。
------解决方案--------------------------------------------------------
select * from ( select to_date('2008-01-01','yyyy-mm-dd')+LEVEL-1 as time from dual CONNECT BY to_date('2008-01-01','yyyy-mm-dd')+LEVEL<=to_date('2008-02-01','yyyy-mm-dd')+1 ) WHERE trim(to_char(TIME,'day','NLS_DATE_LANGUAGE = American')) IN ('monday','tuesday','wednesday','thursday ','friday')
这个是我昨天写的,不太好