oracle获取某时间段内的年份、月份、日期列表,oracle年份
获取日期列表:
SELECT TO_CHAR(TO_DATE('2014-10-01', 'yyyy-MM-dd') + ROWNUM - 1, 'yyyyMMdd') as daylist FROM DUAL CONNECT BY ROWNUM <= trunc(to_date('2015-06-01', 'yyyy-MM-dd') - to_date('2014-10-01', 'yyyy-MM-dd')) + 1
获取月份列表:
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2014-10', 'yyyy-MM'), ROWNUM - 1), 'yyyyMM') as monthlist FROM DUAL CONNECT BY ROWNUM <= months_between(to_date('2015-06', 'yyyy-MM'), to_date('2014-10', 'yyyy-MM')) + 1
获取年份列表:
SELECT TO_CHAR(ADD_MONTHS(TO_DATE('2014-10', 'yyyy-MM'), (ROWNUM - 1) * 12), 'yyyy') as yearlist FROM DUAL CONNECT BY ROWNUM <= months_between(to_date('2015-06', 'yyyy-MM'), to_date('2014-10', 'yyyy-MM')) / 12 + 1
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。