-- 数据今天的日期:
-- select t1.RATIOVALUE from tableName t1 where trunc(t1.STATICTIME) = trunc(sysdate);
-- 查询上周最后一天日期
-- select TO_CHAR((select trunc(sysdate,'d')-1 from dual),'YYYY-MM-DD') from dual;
-- 查询上个月的最后一天日期
-- select TO_CHAR((select trunc(sysdate,'mm')-1 from dual),'YYYY-MM-DD') from dual;