sql - 如何在 Oracle 查询中的两个给定日期之间选择日期？

Question

如何在 Oracle 查询中的两个给定日期之间选择日期？

Answer 1

SELECT TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum AS d
FROM all_objects
WHERE TO_DATE('12/01/2003', 'MM/DD/YYYY') - 1 + rownum <= TO_DATE('12/05/2003', 'MM/DD/YYYY')

从

http://forums.devshed.com/oracle-development-96/select-all-dates-between-two-dates-92997.html