Oracle Functions 获取具体日期

发表于 分类于

教务考勤：根据学期、周次、星期几返回具体日期（格式：2019-11-22）

1
2
3
4
5
6
7
8
9
10
11
create or replace function fun_get_date(termNo    in number,
                                        weekOrder in number,
                                        weekNum   in number) return varchar is
  result_date varchar2(200);
begin
  select to_char(to_date(cal.startdate, 'yyyy-MM-dd') + 7 * (weekOrder - 1) + (weekNum - 1), 'yyyy-MM-dd')
    into result_date
    from TAB_KQ_CALENDAR cal
   where cal.bh = termNo;
  return result_date;
end;