SELECT TO_CHAR(ADD_MONTHS(TO_DATE(TO_CHAR(sysdate, 'yyyy')|| '-01','yyyy-MM'), ROWNUM - 1), 'yyyy-MM') as year_month
FROM DUAL CONNECT BY ROWNUM <= months_between(TO_DATE(TO_CHAR(sysdate, 'yyyy-MM'), 'yyyy-MM'), TO_DATE(TO_CHAR(sysdate, 'yyyy')|| '-01', 'yyyy-MM')) + 1
Oracle 获取当前年第一个月至当前月
最新推荐文章于 2024-08-13 13:38:46 发布
![](https://img-home.csdnimg.cn/images/20240711042549.png)