select * from
(
select (trunc(sysdate,'mm')+level-1) as dt from dual
connect by rownum<=35
)
where trunc(sysdate,'mm')=trunc(dt,'mm')
orcale 获得一个月的日期
最新推荐文章于 2021-04-27 16:47:53 发布
select * from
(
select (trunc(sysdate,'mm')+level-1) as dt from dual
connect by rownum<=35
)
where trunc(sysdate,'mm')=trunc(dt,'mm')