--一天
select * from a where createTime>= SYSDATE-1;
--一周
select * from a where createTime>= SYSDATE-7;
--一月
select * from a where createTime>= SYSDATE-interval '1' month;
--一年
select * from a where createTime>= SYSDATE-interval '12' month;
--一天
select * from a where createTime>= SYSDATE-1;
--一周
select * from a where createTime>= SYSDATE-7;
--一月
select * from a where createTime>= add_months(SYSDATE,-1);
--一年
select * from a where createTime>= add_months(SYSDATE,-12);
select * from a where createtime>=sysdate-1 --24小时
select * from a where createtime>=sysdate-7--一周
select * from a where createtime>=TO_DATE(TO_CHAR(SYSDATE, 'YYYY-MM') ||
'-01 00:00:01',
'YYYY-MM-DD HH24:MI:SS') --从月初到现在的所有