On Tue, 10 Aug 1999, Wim Kerkhoff wrote:
> Hi,
>
> I am creating a script that sends out reminders to subscribers to a site who
> have not paid. I can't figure out the math that will add 7 days to a date.
>
> I want something like this:
>
> select * from company where created
> is between (lastpaid + 14 days) and (created + 28 days);
>
> I can't figure out the syntax that will let me add days to a date. I checked
> the archives and the Postgresql doc's, but nothing.
>
> Ideas?
>
> Thanks,
>
> Wim Kerkhoff.
>
>
Use the ::reltime specifier, e.g.
select * from company
WHERE created > (lastpaid + ('14 days'::reltime))::datetime
AND created < (lastpaid + ('28 days'::reltime))::datetime;
Although I suspect you need "- ('14 days'..." if you are talking about the
past.
The date functions are documented very well in the postgres docs, specifically
the user section.
Simon.
--
"Don't anthropomorphise computers - they don't like it."
Simon Drabble It's like karma for your brain.
simon@eskimo.com