Select dates between two dates

From: Yann Doussot <doussot_at_gifrance.com>
Date: 28 Dec 1998 20:41:49 GMT
Message-ID: <slrn78fr8d.dk3.doussot@draco.gifrance.com>

        Hello,

        I would like to create a query (or procedure/function/package ...) that returns days between two dates. Eg:

select ...(sysdate, sysdate + 2);

1998-12-28
1998-12-29
1998-12-30

	Datas must be returned as a table because I need to perfom a

join with other tables.

        (Oracle 8.0.5)

        Thanks for any hints.

---
Yann Doussot <doussot_at_gifrance.com>
Grey Interactive - France - http://www.gifrance.com/ Cell: +33 6 12 71 70 03 Work: + 33 1 46 84 85 00 Received on Mon Dec 28 1998 - 14:41:49 CST