- 上个月最后一天
1)
select date_sub(now(),interval EXTRACT(day FROM now()) day)
EXTRACT(day FROM ?) 获取时间的 的day
interval ? day 间隔天数
date_sub() 减去天数
2)
last_day(date_sub(now(),interval 1 month))
- 上一个月
date_sub(now(),interval 1 month) 上个月
- 1号
date_format(now(),'%Y-%m-%01')
获取1号到月末
SELECT @num := @num + 1 num,
DATE_ADD(date_format(now(),'%Y-%m-%d'),INTERVAL @num day) dt
FROM area a,(SELECT @num := -1) num_t
WHERE @num < EXTRACT(day FROM LAST_DAY(now())) - 1
SELECT
@num := @num + 1 num,
DATE_ADD(
DATE_FORMAT( DATE_ADD( curdate( ), INTERVAL - DAY ( curdate( ) ) + 1 DAY ), '%Y-%m-%d' ),
INTERVAL @num DAY
) AS dt
FROM
area a,
( SELECT @num :=- 1 ) num_t
WHERE
@num < ( SELECT DAYOFMONTH( LAST_DAY( DATE_FORMAT( now( ), '%Y-%m-%d' ) ) ) - 1 )