关于时间

季度：

select to_char(sysdate,'Q')a from dual

所在季度的三个自然月：

select to_char(add_months(add_months(trunc(sysdate, 'yyyy'),a * 3),-rownum),'yyyymm')   
from (select to_char(sysdate,'Q')a from dual)  
connect by rownum <= 3

周：

select to_char(sysdate,'IW') from dual;

近6个月：

select to_char(add_months(sysdate,1-rownum),'yyyymm')   from dual
connect by rownum <= 6