msql常用日期、月份查询:本周、上周、本月、上月
查询当月明细数据
select * from tablename twhere 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 twhere 1=1and 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 '本月末'