例:当前月前12个月(包括当前月)
SELECT
TO_CHAR(
ADD_MONTHS(
TO_DATE(
to_char(SYSDATE,‘yyyymm’),‘yyyyMM’
), ROWNUM - 12
),‘yyyyMM’
)
as MONTH FROM DUAL
CONNECT BY ROWNUM <= 12
oracle获取当前月的前n个具体月份
最新推荐文章于 2024-07-21 22:27:18 发布
例:当前月前12个月(包括当前月)
SELECT
TO_CHAR(
ADD_MONTHS(
TO_DATE(
to_char(SYSDATE,‘yyyymm’),‘yyyyMM’
), ROWNUM - 12
),‘yyyyMM’
)
as MONTH FROM DUAL
CONNECT BY ROWNUM <= 12