select rlmonth from
(
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,1-LEVEL),'YYYY.MM') rlmonth FROM DUAL CONNECT BY LEVEL <=12
) a
where substr(rlmonth,0,4) = to_char(sysdate,'yyyy')
oracle获取当年1月到当前月
最新推荐文章于 2023-08-11 09:34:58 发布
select rlmonth from
(
SELECT TO_CHAR(ADD_MONTHS(SYSDATE,1-LEVEL),'YYYY.MM') rlmonth FROM DUAL CONNECT BY LEVEL <=12
) a
where substr(rlmonth,0,4) = to_char(sysdate,'yyyy')