- s是开始日期，e是结束日期
-
-
create or replace function workday(s in date,e in date) RETURN INTEGER
-
as
-
result integer;
-
begin
-
select count(*) into result from (
- select to_char(s+level-1,'d') w,s+level-1 from dual connect by level<=(e-s+1)
-
)
-
where w not in ('1','7');
-
return result;
- end workday;
- /
SQL> select workday(to_date('20131101','yyyymmdd'),to_date('20131115','yyyymmdd')) workday from dual;
WORKDAY
----------
11
SQL> select workday(to_date('20131101','yyyymmdd'),to_date('20131125','yyyymmdd')) workday from dual;
WORKDAY
----------
17
SQL> select workday(to_date('20131101','yyyymmdd'),to_date('20131130','yyyymmdd')) workday from dual;
WORKDAY
----------
21
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29254281/viewspace-775663/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
行转列
下一篇：
删除一个用户下所有的对象
请登录后发表评论
登录
全部评论
