1.求出本星期的第一天日期(以星期一为第一天) 请输入占位符
select trunc(sysdate,'DD')-to_char(sysdate,'D')+2-(to_number(to_char(sysdate,'IW'))-&week)*7 from dual;
2.求出本星期的第七天日期(以星期日为第七天)
select trunc(sysdate,'DD')-to_char(sysdate,'D')+8-(to_number(to_char(sysdate,'IW'))-&week)*7 from dual;