Re: [GENERAL] Selecting between dates

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(at)eskimo(dot)com