1、这条sql语句查询出来的将会是2015-01-01至2016-09-01'所有的月份。
select to_char(dt, 'yyyy/MM') as dat
from (select date '2015-01-01' + (rownum - 1) dt
from dual
connect by rownum <= (date '2016-09-01' - date '2015-01-01' + 1))
group by to_char(dt, 'yyyy/MM') order by dat;
2、这条语句查询出来的是日期范围内的所有天数
select date '2015-01-01' + (rownum - 1) dt
from dual
connect by rownum <= (date '2016-09-01' - date '2015-01-01' + 1)
这都是从网上看到的,希望能对别人有用!