oracle根据日期显示星期几,Oracle获取周几以及每周对应得开始日期和结束日期

Oracle获取周几以及每周对应得开始日期和结束日期

--获取近一年周的开始日期和结束日期,从星期日开始

select

'2014'||sunday.the_week,decode(sign(sunday.the_day-saturday.the_day),-1,sunday.the_day,sunday.the_day-7)

sunday,saturday.the_day saturday from

(select to_char(wwm,'WW') the_week,to_char(wwm,'D') the_daynum,wwm the_day from (select

trunc(to_date('2014-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as wwm from user_objects where rownum < 366) where

to_char(wwm,'D')=1 ) sunday,

(select to_char(wwm,'WW') the_week,to_char(wwm,'D') the_daynum,wwm the_day  from (select

trunc(to_date('2014-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as wwm from user_objects where rownum < 366) where

to_char(wwm,'D')=7 ) saturday

where sunday.the_week=saturday.the_week;

--获取近一年周的开始日期和结束日期,从星期一开始

select

'2014'||monday.the_week,decode(sign(monday.the_day-sunday.the_day),-1,monday.the_day,monday.the_day-6)

sunday,sunday.the_day sunday from

(select to_char(wwm,'WW') the_week,to_char(wwm,'D') the_daynum,wwm the_day from (select

trunc(to_date('2014-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as wwm from user_objects where rownum < 366) where

to_char(wwm,'D')=1 ) monday,

(select to_char(wwm,'WW') the_week,to_char(wwm,'D') the_daynum,wwm+1 the_day  from (select

trunc(to_date('2014-01-01','yyyy-mm-dd'), 'MM')+rownum-1 as wwm from user_objects where rownum < 366) where

to_char(wwm,'D')=7 ) sunday

where monday.the_week=sunday.the_week;

0b1331709591d260c1c78e86d0c51c18.png

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值