Oracle obtains all hours, days, and months in a period of time

Get all the hours in a while

SELECTTo_date ('2013-07-01','YYYY-MM-DD hh24')+(ROWNUM- 1)/  -Sdate fromDualconnect byROWNUM<=(To_date ('2013-07-02','YYYY-MM-DD hh24')-To_date ('2013-07-01','YYYY-MM-DD hh24'))*  - + 1;

Get all the days in a while

SELECTTo_date ('2013-07-01','YYYY-MM-DD')+ROWNUM- 1Sdate fromDual CONNECT byROWNUM<=To_date ('2013-07-05','YYYY-MM-DD')-To_date ('2013-07-01','YYYY-MM-DD')+ 1;SelectTo_date ('2013-01-01','YYYY-MM-DD')+RowNum- 1    fromuser_objectswhereRowNum<=(To_date ('2013-01-14','YYYY-MM-DD')-To_date ('2013-01-01','YYYY-MM-DD')+ 1);

Get all the months in a while

SELECTTo_char (Add_months (To_date ('2013-01','yyyy-mm'), ROWNUM- 1),'yyyy-mm') day_id fromDualconnect byROWNUM<=Months_between (To_date ('2013-07','yyyy-mm'), To_date ('2013-01','yyyy-mm'))+ 1;

This article transferred from: http://blog.csdn.net/ld422586546/article/details/9626921

Reference: http://www.2cto.com/database/201301/183230.html

Oracle obtains all hours, days, and months in a period of time