Re: [GENERAL] Selecting between dates

[Aaron Seigo]

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)

Aaron J. Seigo
Systems Analyst/Administrator