SELECT
DATE_FORMAT( CURDATE(), '%Y-%m' ) AS MONTH UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 1 MONTH ), '%Y-%m' ) AS MONTH UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 2 MONTH ), '%Y-%m' ) AS MONTH UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 3 MONTH ), '%Y-%m' ) AS MONTH UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 4 MONTH ), '%Y-%m' ) AS MONTH UNION
SELECT
DATE_FORMAT(( CURDATE() - INTERVAL 5 MONTH ), '%Y-%m' ) AS MONTH
Mysql查询当前日期前六个月
最新推荐文章于 2024-05-22 10:13:27 发布