当天,本周,本月

当天
TO_DAYS(createTime) = TO_DAYS(NOW())
本周
YEARWEEK(DATE_FORMAT(createTime,'%Y-%m-%d'),1) = YEARWEEK(NOW(),7)
本月
DATE_FORMAT(createTime,'%Y-%m') = DATE_FORMAT(NOW(),'%Y-%m')

posted @ 2022-06-07 20:33  形码客  阅读(32)  评论(0)    收藏  举报