如何获取某一周的起止日期

[zhaozheng821018]

在oracle中如何获取某一周的起止日期

[bw555]

select next_day(sysdate-1,1) as 起始日期，next_day(sysdate-1,1)+6 as 截止日期 from dual;

[Allan_xd]

select trunc(sysdate,'yyyy') + mod(8 - to_number(to_char(trunc(sysdate,'yyyy'),'d')),7) + weeknum * 7 - 7 as sundayoftheweek from dual;

语句中weeknum是年中的周数，返回周内的星期日，这个日期+6即是周末。

[Allan_xd]

或
select trunc(sysdate,'yyyy') - to_char(trunc(sysdate,'yyyy'),'d') - 1 + :weeknum * 7 as sundayoftheweek from dual;

[Allan_xd]

上面错了
select trunc(sysdate,'yyyy') - to_char(trunc(sysdate,'yyyy'),'d') + 1 + :weeknum * 7 as sundayoftheweek from dual;