sql查询某个时间内的数据

select * from sys_member where create_time >=(NOW() - interval 24 hour)

 

七天之前的数据
SELECT * FROM commodity_order where create_time <= (now()-INTERVAL 7 DAY) order by create_time desc