今天
TO_DAYS(create_time) = TO_DAYS(NOW())
昨天
TO_DAYS(create_time) = (TO_DAYS(NOW())-1)
本周
YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now()
YEARWEEK(date_format(create_time,'%Y-%m-%d'),1) = YEARWEEK(now(),1))
上周
YEARWEEK(date_format(create_time,'%Y-%m-%d')) = YEARWEEK(now())-1)
YEARWEEK(date_format(create_time,'%Y-%m-%d'),1) = (YEARWEEK(now(),1)-1)
本月
date_format(create_time,'%Y-%m')=date_format(now(),'%Y-%m')
上月
PERIOD_DIFF( date_format( now( ) , '%Y%m' ) , date_format( create_time, '%Y%m' ) ) =1