为提高效率,提问时请提供以下信息,问题描述清晰可优先响应。
【DM版本】:
【操作系统】:
【CPU】:
【问题描述】*:
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"
union
select date_format((curdate() - interval 0 month),'%Y-%m') AS "MONTH"
select to_char(DATEADD(MONTH,-1,curdate()),'yyyy-mm') from dual;
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, -1), 'YYYY-MM') AS "MONTH"
UNION
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, -2), 'YYYY-MM') AS "MONTH"
UNION
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, -3), 'YYYY-MM') AS "MONTH"
UNION
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, -4), 'YYYY-MM') AS "MONTH"
UNION
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, -5), 'YYYY-MM') AS "MONTH"
UNION
SELECT TO_CHAR(ADD_MONTHS(CURRENT_DATE, 0), 'YYYY-MM') AS "MONTH";