查询出2013-12-31和2014-01-03内的所有日期
from dual
connect by level <=to_date('2014-01-03','yyyy-mm-dd')-to_date('2013-12-31','yyyy-mm-dd')+1
效果:
2013-12-31
2014-01-01
2014-01-02
2014-01-03
查询出2013-12-31和2014-01-03内的所有日期
from dual
connect by level <=to_date('2014-01-03','yyyy-mm-dd')-to_date('2013-12-31','yyyy-mm-dd')+1
效果:
2013-12-31
2014-01-01
2014-01-02
2014-01-03