mysql查询一天，一周等隔日数据
--查询一天
select * from tbl_order where date(tbor_create_time) = curdate();
select * from tbl_order where to_days(tbor_create_time) = to_days(now());
--查询一个周
select * from tbl_order where date_sub(curdate(), interval 7 day)
--查询一个月
select * from tbl_order where date_sub(curdate(), interval 30 day)
--两个日期之间的数据
select * from tbl_order where tbor_create_time>'2012-01-20 00:00:00' and tbor_create_time
bitscn.com