MySQL当前日期的前12个月

原创于 2023-08-12 17:59:49 发布 · 466 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sql

本文介绍了一个MySQL查询语句，用于获取一年前的特定月份数据，通过DATE_FORMAT函数和interval运算实现动态范围。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

select DATE_FORMAT(date_add(date_add(now(), interval -1 year), interval row1 MONTH),'%Y-%m') date from
(
SELECT @row := @row + 1 as row1 FROM
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t,
(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) t2,
(SELECT @row:=-1) r
) se
where DATE_FORMAT(date_add(date_add(now(), interval -1 year), interval row1 MONTH),'%Y-%m') <= DATE_FORMAT(now(),'%Y-%m')