select * from eo_c_order t

where t.create_time>systimestamp-interval'1'day;