摘要:
create or replace function get_workday(starTime in date,endTime in date) return numberis Weekends number; Holidays number; Workdays number;begin--统计开始到结束有几天周末 select count(*) into Weekends from( SELECT TO_CHAR (TRUNC (starTime, 'DD') - 1 + ROWNUM, 'D') week_no FROM all_objects W... 阅读全文