mysql查询日期：本周、上周、本月、上月

msql常用日期、月份查询：本周、上周、本月、上月

查询当月明细数据

select * from tablename t
where date_format(curdate(),'%y%m') = date_format(create_time,'%y%m')

当前年月日

select  CURRDATE()  as '当天'

 本周

select yearweek(now(),1)  '本周'

上周

select yearweek(now(),1) -1 '上周'

查询上周数据

select * form tablename t
where 1=1
and yearweek(date_format(t.create_date,'%Y-%m-%d'),1) >=  yearweek(now(),1)-1  --大于等于上周
and yearweek(date_format(t.create_date,'%Y-%m-%d'),1) <  yearweek(now(),1) --小于本周

本月初

select  DATE_FORMAT(CURDATE(),'%Y-%m-01 00:00:00') as '本月初'

本月末

select  DATE_FORMAT(LAST_DAY（CURDATE()）,'%Y-%m-01 23:59:59') as '本月末'