MySQL按照月 周 天分类查询,划分每天的时间段查询**
1.查询当前天
SELECT * FROM edu_experimentreservation WHERE year(creation)=year(now()) and month(creation) = month(now()) and day(creation) = day(now());
2.查询当前周
SELECT * FROM edu_experimentreservation WHERE YEARWEEK(date_format(creation,’%Y-%m-%d’)) = YEARWEEK(now());
3.查询当前天
SELECT * FROM edu_experimentreservation WHERE date_format(creation,’%Y-%m’) = date_format(now(),’%Y-%m’);
4.每天按照两个小时进行划分查询
SELECT (count(HOUR(c.creation)=‘0’ or null ) +count(HOUR(c.creation)=‘1’ or null ) ) as ‘0-1’,
(count(HOUR(c.creation)=‘2’ or null ) +count(HOUR(c.creation)=‘3’ or null ) ) as ‘2-3’,
(count(HOUR(c.creation)=‘4’ or null ) +count(HOUR(c.creation)=‘5’ or null ) ) as ‘4-5’,
(count(HOUR(c.creation)=‘6’ or n