mysql 本周 上周 本月 上月SQL 语句

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