Re: All Dates

From: trevor burkin <trevor.2.burkin_at_bt.com>
Date: Wed, 27 Sep 2000 13:55:12 +0100
Message-ID: <39D1EE2F.9706EB5D@bt.com>

Hope this helps

select to_date('&1','ddmmyyyy') + rownum - 1 from table_with_more_rows_than_dates_required where rownum <= to_date('&2','ddmmyyyy') - to_date('&1','ddmmyyyy') + 1

Regards Trevor

Ganesh R wrote:

> Hi,
>
> I want to fetch all the dates btw. to given dates. This can be achived
> thru PL?SQL but i want to get it thru a Select Statement.
>
> Any Help
>
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
> --
> Regards,
> Ganesh R
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 27 2000 - 07:55:12 CDT