計算某時間段內ERP中的節假日中應排除的天數

longwansheng發表於2011-06-16
create or replace function gobo_calendar_exception_dates(incode in varchar2,fdate in date,add_days in number) return number is rnum number; begin select 0 - (select count(1) from BOM_CALENDAR_EXCEPTIONS --BOM_CALENDAR_DATES --BOM_CALENDARS where calendar_code=incode and exception_set_id=-1 and exception_type=2 and exception_date>=fdate and exception_date=fdate and exception_date[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/92289/viewspace-1051226/,如需轉載,請註明出處,否則將追究法律責任。

相關文章