oracle 月份补全与日期补全
--得到这一年中的所有月份
SELECT TO_CHAR(ADD_MONTHS(DATE '2004-01-01', ROWNUM-1 ), 'yyyyMM' ) AS year_month
?????????? FROM?? dual
?????????? CONNECT BY ROWNUM <= 12
?
结果如下:
year_month
200401
200402
200403
200404
200405
200406
200407
200408
200409
200410
200411
200412
?
--得到两个日期之间所有的天数????
select to_date('2012-05-25','yyyy-mm-dd')+(ROWNUM-1) as year_month_day from dual
???? CONNECT BY ROWNUM <=
? ??? (to_date('2012-06-5','yyyy-mm-dd') - to_date('2012-05-25','yyyy-mm-dd'))+1
?
结果如下:
year_month_day
2012-5-25
2012-5-26
2012-5-27
2012-5-28
2012-5-29
2012-5-30
2012-5-31
2012-6-1
2012-6-2
2012-6-3
2012-6-4
2012-6-5
?
?
