当天，本周，本月

当天
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')