MySQL按照月 周 天分类查询,划分每天的时间段查询
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(cre
原创
2020-11-11 14:03:01 ·
562 阅读 ·
0 评论