SELECT EXTRACT(YEAR_MONTH FROM NOW()) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 1 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 2 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 3 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 4 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 5 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 6 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 7 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 8 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 9 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 10 MONTH)) yearmonth
UNION
SELECT EXTRACT(YEAR_MONTH FROM DATE_SUB(NOW(),INTERVAL 11 MONTH)) yearmonth
mysql 查询最近12个月日期
最新推荐文章于 2024-02-19 21:45:20 发布