oracle根据当前日期截取一周时间_hanCSDN_20130503

declare
begindate date;
enddate date;
daystr varchar2(20);

begin
  select to_char(sysdate,'day') into daystr from dual;
  if(daystr='星期一') then
           begindate :=sysdate;
           enddate := sysdate+6;
  elsif(daystr='星期二') then
           begindate :=sysdate-1;
           enddate := sysdate+5;
  elsif(daystr='星期三') then
           begindate :=sysdate-2;
           enddate := sysdate+4;
  elsif(daystr='星期四') then
           begindate :=sysdate-3;
           enddate := sysdate+3;
  elsif(daystr='星期五') then
           begindate :=sysdate-4;
           enddate := sysdate+2;
   elsif(daystr='星期六') then
           begindate :=sysdate-5;
           enddate := sysdate+1;
   elsif(daystr='星期日') then
           begindate :=sysdate-6;
           enddate := sysdate;
    end if;
    dbms_output.put_line(sysdate);
    dbms_output.put_line(begindate);
    dbms_output.put_line(enddate);
end;