--以星期天为一周的开始 select count(*) from a where create_date between trunc(sysdate,'d') and trunc(sysdate,'d')+7 --以星期一为一周的开始 select count(*) from a where create_date between trunc(sysdate,'d')+1 and trunc(sysdate,'d')+8
select count(*) from A where create_date>next_day(sysdate,'星期日')-7
--以星期天为一周的开始
select count(*)
from a
where create_date between trunc(sysdate,'d') and trunc(sysdate,'d')+7
--以星期一为一周的开始
select count(*)
from a
where create_date between trunc(sysdate,'d')+1 and trunc(sysdate,'d')+8