Oracle列出指定日期段内的日期
Oracle列出指定日期段内的日期
SELECT TO_CHAR(to_date('2015/08/01', 'yyyy/mm/dd') + (level - 1), 'yyyy/mm/dd') DD
FROM dual
CONNECT BY TRUNC(to_date('2015/08/01', 'yyyy/mm/dd')) + level - 1 < TRUNC(to_date('2015/08/10', 'yyyy/mm/dd'))
Oracle列出指定日期段内的日期
SELECT TO_CHAR(to_date('2015/08/01', 'yyyy/mm/dd') + (level - 1), 'yyyy/mm/dd') DD
FROM dual
CONNECT BY TRUNC(to_date('2015/08/01', 'yyyy/mm/dd')) + level - 1 < TRUNC(to_date('2015/08/10', 'yyyy/mm/dd'))
