Re: [GENERAL] Selecting between dates

Thanks Aaron,

That is exactly what I wanted.  Much more simple then what I was thinking.


On 10-Aug-99 Aaron Seigo wrote:
> hi wim..
>
>>select * from company where created
>>is between (lastpaid + 14 days) and (created + 28 days);
>
> assuming that lastpaid and created are dates, pgsql will handle the
> addition quite nicely for you... as examples:
>
> test=> select '4-1-1999'::date + 7;
>   ?column?
> ----------
> 04-08-1999
> (1 row)
>
> test=> select '4-26-1999'::date + 7;
>   ?column?
> ----------
> 05-03-1999
>
> test=> select '12-26-1999'::date + 7;
>   ?column?
> ----------
> 01-02-2000
> (1 row)
>

Regards,
---------------------------
 Wim Kerkhoff
 wim@netmaster.ca
 www.canadianhomes.net/wim
 ICQ: 23284586