实际应用中举例
select sum(decode(SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy-MM-dd'),0,10),TO_CHAR (SYSDATE, 'yyyy-MM-dd'),1,0)) AS "sumOfficeDay", sum(decode(SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy-MM-dd'),0,10),TO_CHAR (SYSDATE - 1, 'yyyy-MM-dd'),1,0)) AS "sumOfficeLastDay", sum(decode(SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy-MM'),0,10),TO_CHAR (SYSDATE, 'yyyy-MM'),1,0)) AS "sumOfficeMonth", sum(decode((SUBSTR(TO_CHAR(CREATE_DATE, 'yyyy'),0,4)+SUBSTR(TO_CHAR(CREATE_DATE, 'iw'),0,10)),(SUBSTR(TO_CHAR(SYSDATE, 'yyyy'),0,4)+TO_CHAR (SYSDATE, 'iw')),1,0)) AS "sumOfficeWeek" from SYS_OFFICE