Re: A tricky sql date question

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 22 Nov 2000 08:48:48 -0000
Message-ID: <974879385.13786.1.nnrp-01.9e984b29@news.demon.co.uk>

Have a look at my website under:

Developer Tricks -> Dummy Data

--
Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Practical Oracle 8i:  Building Efficient Databases

Publishers:  Addison Wesley Longman
Book bound date: 8th Dec 2000
See a first review at:
http://www.ixora.com.au/resources/index.htm#practical_8i
Order from Amazon via: http://www.jlcomp.demon.co.uk

seanfour_at_my-deja.com wrote in message <8ve1b5$h64$1_at_nnrp1.deja.com>...


>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.

Received on Wed Nov 22 2000 - 02:48:48 CST