- /* 查询2013-11-25至2014-12-28内所有日期天数 */
- select
- date '2013-11-25' + (rownum - 1) dt
- from dual connect by rownum <= (date '2014-12-28' - date '2013-11-25' + 1)
- /* 查询2013-11-25至2014-12-28包含的月份,以及每月包含的天数 */
- select
- to_char(dt,'yyyy-mm'),
- count(to_char(dt,'yyyy-mm')) days,
- mm
- from(
- select
- date'2013-11-25' + (rownum - 1) dt,
- to_char(last_day(date'2013-11-25' + (rownum - 1)),'mm') mm
- from dual connect by rownum <= (date'2014-12-28' - date'2013-11-25' + 1)
- )
- group by to_char(dt,'yyyy-mm'),mm
- order by to_char(dt,'yyyy-mm')
- --该片段来自于http://www.codesnippet.cn/detail/2407201410046.html
来源: http://www.codesnippet.cn/detail/2407201410046.html