Mysql queries data from one day, one week, and the other day _ MySQL

Mysql queries the data of bitsCN.com every other day for one day and one week.

Mysql queries data from one day, one week, and the other day

-- Query a day

Select * from tbl_order where date (tbor_create_time) = curdate ();

Select * from tbl_order where to_days (tbor_create_time) = to_days (now ());

-- Query a week

Select * from tbl_order where DATE_SUB (CURDATE (), INTERVAL 7 DAY) <= date (tbor_create_time );

-- Query a month

Select * from tbl_order where DATE_SUB (CURDATE (), INTERVAL 30 DAY) <= date (tbor_create_time );

-- Data between two dates

Select * from tbl_order where tbor_create_time> '2017-01-20 00:00:00 'and tbor_create_time <'2017-02-7 00:00:00 ';

BitsCN.com