FUN_SYS_GET_CALENDAR_WEEK(4)
来源:互联网 发布:windows xp好还是7好 编辑:程序博客网 时间:2024/04/28 00:21
/*
desription Get the week of before first sunday.
parameter vd_first_week_date
*/
if vd_deal_date < vd_first_week_date then
/*
desription Get the last week of last year when first week start with Jan 1st.
*/
if to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd'),'D') = '1' then
ov_return := to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'1231','yyyymmdd'),'yyyyww');
else
/*
desription Get the date of the first sunday of last year.
*/
vi_loop_num := 1;
loop
if vi_loop_num > 6 then
exit;
else
if to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd')+vi_loop_num,'D') = 1 then
vd_first_week_date1 := to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd')+vi_loop_num;
exit;
else
vi_loop_num := vi_loop_num+1;
desription Get the week of before first sunday.
parameter vd_first_week_date
*/
if vd_deal_date < vd_first_week_date then
/*
desription Get the last week of last year when first week start with Jan 1st.
*/
if to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd'),'D') = '1' then
ov_return := to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'1231','yyyymmdd'),'yyyyww');
else
/*
desription Get the date of the first sunday of last year.
*/
vi_loop_num := 1;
loop
if vi_loop_num > 6 then
exit;
else
if to_char(to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd')+vi_loop_num,'D') = 1 then
vd_first_week_date1 := to_date(to_char(vd_deal_date,'yyyy') - 1||'0101','yyyymmdd')+vi_loop_num;
exit;
else
vi_loop_num := vi_loop_num+1;
0 0
- FUN_SYS_GET_CALENDAR_WEEK(4)
- FUN_SYS_GET_CALENDAR_WEEK
- FUN_SYS_GET_CALENDAR_WEEK(2)
- FUN_SYS_GET_CALENDAR_WEEK(3)
- FUN_SYS_GET_CALENDAR_WEEK(5)
- FUN_SYS_GET_CALENDAR_WEEK(6)
- FUN_SYS_GET_CALENDAR_WEEK(7)
- FUN_SYS_GET_CALENDAR_WEEK(8)
- FUN_SYS_GET_CALENDAR_WEEK(8)
- FUN_SYS_GET_CALENDAR_WEEK(9)
- 4
- 4
- (4)
- 4
- 4
- 4
- 4
- 4
- org.apache.jasper.JasperException: Unable to compile class for JSP:
- 第二周 项目一:三角形类1
- Linux - 文件 /dev/null 和 /dev/zero
- Android16_WebView
- Android命令总结
- FUN_SYS_GET_CALENDAR_WEEK(4)
- 抽象数据类型线性表的定义—链表操作
- 构造HTTP请求Header实现“伪造来源IP”
- 从智慧树上找到的心率计算matlab代码
- Flash Media Server 4.5 配置
- Android事件处理
- AngularJs错误:Error: [$resource:badcfg] Error in resource configuration
- FUN_SYS_GET_CALENDAR_WEEK(5)
- 4.2、消息映射机制原理