Mysql查询当前日期前六个月

SELECTDATE_FORMAT( CURDATE(), '%Y-%m' ) AS MONTH UNIONSELECTDATE_FORMAT(( CURDATE() - INTERVAL 1 MONTH ), '%Y-%m' ) AS MONTH UNIONSELECTDATE_FORMAT(( CURDATE() - INTERVAL 2 MONTH ), '%Y-%m' ) AS MONTH

ChristXlx

4851人浏览 · 2021-11-18 11:18:48

ChristXlx · 2021-11-18 11:18:48 发布

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