Re: seleting all dates between two dates

On Fri, 1 Jun 2001 15:09:33 -0400
"Jeff Barrett" <jbarrett(at)familynetwork(dot)com> wrote:
> I am interested in a query where I can select all dates between two dates. I
> figure I can build a table of all valid dates with a resonable range and
> then select from that table, but I would like to use the power of sql to get
> the work done without building a date table. Any ideas?
>
> For example:
> I want all dates between 05-29-2001 and 06-02-2001
> The result set would be:
> 05-30-2001
> 05-31-2001
> 06-01-2001

You got it almost right already! Use the "between" operator; *sometimes* SQL *is* intuitive:
E.g. in my database:

select run_name from runs where comp_date between '2001-may-10' and '2001-jun-5';
run_name | comp_date
------------------+------------------------
spcsil-103-RP | 2001-06-04 21:09:35-04
airtest_0120 | 2001-05-21 20:10:50-04
spcsil-101-RP | 2001-05-23 17:44:11-04
...

--
Your mouse has moved.
Windows NT must be restarted for the change to take effect.
Reboot now? [OK]