oracle查询当前系统时间前10天的数据

select * from eo_c_order t
where t.create_time>systimestamp-interval'1'day;

转载于:https://www.cnblogs.com/21heshang/p/6437293.html