orcale常用时间查询

查询最近一周数据
SELECT * FROM GTMS_KEYKPI WHERE TO_CHAR(CREATE_DATE,‘YYYY-MM-DD’)=TO_CHAR(SYSDATE,‘YYYY-MM-DD’)
查询最近一个月数据
SELECT * FROM GTMS_KEYKPI WHERE TO_CHAR(CREATE_DATE,‘YYYY-MM’)=TO_CHAR(SYSDATE,‘YYYY-MM’)
查询最近一季度数据
SELECT * FROM GTMS_KEYKPI WHERE TO_CHAR(CREATE_DATE,‘q’)=TO_CHAR(SYSDATE,‘q’) and TO_CHAR(CREATE_DATE,‘yy’)=TO_CHAR(sysdate,‘yy’)
查询最近半年数据
SELECT TO_CHAR(add_months(to_date(to_char(trunc(sysdate, ‘mm’)+1, ‘yyyy-mm’), ‘yyyy-mm’), -(ROWNUM - 1)), ‘yyyy-mm’) FROM GTMS_KEYKPI where ROWNUM <= 6