最近 一周
查询最近一周数据
SELECT * FROM DATA_PRESCRIPTION_DETAIL1 WHERE NEW_CREATION_TIME(T_RKSJ,'YYYY-MM-DD')=NEW_CREATION_TIME(SYSDATE,'YYYY-MM-DD')
查询今天数据
SELECT * FROM DATA_PRESCRIPTION_DETAIL1 WHERE NEW_CREATION_TIME(T_RKSJ,'YYYY-MM-DD')=NEW_CREATION_TIME(SYSDATE-1,'YYYY-MM-DD')
查询最近一个月数据
SELECT * FROM DATA_PRESCRIPTION_DETAIL1 WHERE NEW_CREATION_TIME(T_RKSJ,'YYYY-MM')=NEW_CREATION_TIME(SYSDATE,'YYYY-MM')
查询上个月的数据
SELECT * FROM DATA_PRESCRIPTION_DETAIL1 WHERE NEW_CREATION_TIME(T_RKSJ,'YYYY-MM')=NEW_CREATION_TIME(ADD_MONTHS(SYSDATE,-1),'YYYY-MM')
查询上周数据
SELECT * FROM DATA_PRESCRIPTION_DETAIL1 WHERE NEW_CREATION_TIME>= NEW_CREATION_TIME(NEXT_DAY(SYSDATE-8,1)-6) AND NEW_CREATION_TIME< NEW_CREATION_TIME(NEXT_DAY(SYSDATE-8,1)+1)