Re: A tricky sql date question

seanfour_at_my-deja.com wrote:
>
> Is there any way I can list the dates of all the days between 2 dates
> without looping through a select statement from dual? Basically I want
> to be able to give it, say '01-AUG-2001' and '01-AUG-2002' and have it
> spit back all of the dates between without having to hit the DB 365
> times to do it. Thanks for any help!!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Use any table with at least that many rows...

select to_date('01-aug-2000','dd-mon-yyyy')+rownum from <any table>
where rownum < (for example) 60;

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk (mirrored at
http://www.oradba.freeserve.co.uk)

(Apologies for not replying to any emails - YAHOO have a dead server)

"Early to bed and early to rise, 
 makes a man healthy, wealthy and wise." - some dead guy