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

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