Is it possible to generate a range of dates by using plain SQL?
From: Jack Martens <jack.martens_at_cheerful.com>
Date: Thu, 18 Jun 1998 22:26:22 +0200
Message-ID: <6mbt8p$hsu$1_at_thor.wirehub.nl>
Is it possible to generate a range of dates by using plain SQL?
Date: Thu, 18 Jun 1998 22:26:22 +0200
Message-ID: <6mbt8p$hsu$1_at_thor.wirehub.nl>
Is it possible to generate a range of dates by using plain SQL?
Example of the result of the query:
DATE
03-JUN-98 04-JUN-98 05-JUN-98 06-JUN-98 07-JUN-98 08-JUN-98 09-JUN-98 10-JUN-98 11-JUN-98
I must be able to select a date from the resulting rows, like this:
SELECT date
FROM date_table
where date between '05-JUN-98' and '09-JUN-98'
If it is not possible by using plain SQL, what other things could I try (e.g. stored procedures)?
Thanks. Received on Thu Jun 18 1998 - 22:26:22 CEST