SELECT to_date('2009-8', 'YYYY-MM') + ROWNUM - 1
FROM dual
CONNECT BY rownum <
(select trunc(last_day(to_date('2009-8', 'YYYY-MM')))-trunc(add_months(last_day(to_date('2009-8', 'YYYY-MM')),-1)) from dual)
oracle取得某个月所有日期
最新推荐文章于 2024-01-04 16:01:56 发布