SELECT
DATE_FORMAT( m1, '%Y-%m' ) '年月',
date_add( m1, INTERVAL - DAY ( m1 ) + 1 DAY ) '月第一天',
last_day( m1 ) '月最后一天',
curdate() '当前年月日'
FROM
(
SELECT
( '2023-06-01' - INTERVAL DAYOFMONTH( '2023-06-08' )- 1 DAY ) + INTERVAL m MONTH AS m1
FROM
(
SELECT
@rownum := @rownum + 1 AS m
FROM
( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 ) t1,
( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 ) t2,
( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 ) t3,
( SELECT 1 UNION SELECT 2 UNION SELECT 3 UNION SELECT 4 ) t4,
( SELECT @rownum :=- 1 ) t0
) d1
) d2
WHERE
m1 <= '2023-09-08'
ORDER BY
m1
MySQL查询年月,月第一天,月最后一天,当前年月日
最新推荐文章于 2024-05-20 17:20:09 发布