得到本周的数据
select trunc(next_day(sysdate - 8 ,1)+1),trunc(next_day(sysdate,1)) from dual;
select trunc(sysdate,'d')+1,trunc(sysdate,'d')+7 from dual;
得到本周的数据
select trunc(next_day(sysdate - 8 ,1)+1),trunc(next_day(sysdate,1)) from dual;
select trunc(sysdate,'d')+1,trunc(sysdate,'d')+7 from dual;