SELECT TO_CHAR(add_months(add_months(sysdate, -12), ROWNUM - 1), 'MON-yy') AS yearmonth
FROM DUAL
CONNECT BY ROWNUM <=
(SELECT months_between(sysdate, add_months(sysdate, -12))
FROM dual);
- Dec 06 Tue 2022 14:35
-
(Oracle) PL SQL 一年內日期列表
請先 登入 以發表留言。