SELECT TO_CHAR(ADD_MONTHS(SYSDATE,1-LEVEL),'YYYY-MM') FROM DUAL CONNECT BY LEVEL <=6
oracle sql 获取前六个月
最新推荐文章于 2022-09-08 10:48:48 发布
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,1-LEVEL),'YYYY-MM') FROM DUAL CONNECT BY LEVEL <=6