1、本周
YEARWEEK(FROM_UNIXTIME(create_time,'%Y-%m-%d')) = YEARWEEK(now())
2、上周
YEARWEEK(FROM_UNIXTIME(create_time,'%Y-%m-%d')) =YEARWEEK(now())-1
3、本月
FROM_UNIXTIME(create_time,'%Y-%m')=date_format(now(),'%Y-%m')
4、上月
PERIOD_DIFF( date_format( now() , '%Y%m' ) , FROM_UNIXTIME(create_time, '%Y%m' ) ) =1