TO_CHAR(O.RECEIVEDATE,'yyyy-mm-dd') = to_char(sysdate,'yyyy-mm-dd') 当日
---------倒退3天
(trunc(sysdate,'dd') - trunc(O.RECEIVEDATE,'dd')) < 3
AND (trunc(sysdate,'dd') - trunc(O.RECEIVEDATE,'dd')) >=0
-------------------倒退一个月
(TO_CHAR(O.RECEIVEDATE, 'yyyy-mm-dd') >= TO_CHAR(add_months(SYSDATE,-1), 'yyyy-mm-dd'))
AND (TO_CHAR(O.RECEIVEDATE, 'yyyy-mm-dd') <= TO_CHAR(SYSDATE, 'yyyy-mm-dd'))
--------------------系统日期到 本月初
O.RECEIVEDATE >=TRUNC(SYSDATE, 'MM')
AND O.RECEIVEDATE <=last_day(SYSDATE)
----------------------------系统日期 到本周周1
AND O.RECEIVEDATE >=trunc(next_day(sysdate-8,1)+1)
AND O.RECEIVEDATE <=trunc(next_day(sysdate-8,1)+7)+1
--------------上月
AND O.RECEIVEDATE >= TRUNC(add_months(SYSDATE,-1), 'MM')
AND O.RECEIVEDATE <TRUNC(SYSDATE, 'MM')
-------------上周
AND O.RECEIVEDATE >=trunc(next_day(sysdate-15,1)+1)
AND O.RECEIVEDATE <=trunc(next_day(sysdate-15,1)+7)