Loading...
1.今天SELECT * FROM 表名 WHERE TO_DAYS(时间字段名) = TO_DAYS(NOW());2.昨天SELECT * FROM 表名 WHERE TO_DAYS(NOW()) - TO_DAYS(时间字段名) <= 1;3.本周SELECT * FROM 表名 WHERE YEARWEEK(DATE_FORMAT(时间字段名,'%Y-%m-%d')) = YE...