Oracle中查询本月星期5的所有日期列表的语句
程序员文章站
2023-12-04 23:37:58
复制代码 代码如下: select * from (select trunc(sysdate, 'mm') + rownum - 1 days from (select l...
复制代码 代码如下:
select *
from (select trunc(sysdate, 'mm') + rownum - 1 days
from (select level
from dual
connect by level <=
trunc(last_day(sysdate)) - trunc(sysdate, 'mm') + 1))
where to_char(days, 'd') = '6'
作者 scorpio3k