Postgres Pro
Downloads
Home   >   mailing lists

DATE field subtraction - Mailing list pgsql-general

From Ralph Graulich
Subject DATE field subtraction
Date
Msg-id Pine.LNX.4.21.0208191232060.479-100000@shauny.shauny.de
Whole thread Raw
Responses Re: DATE field subtraction  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Tree view 
Hi,


I assume I am just to blind to find it in the documentation: I have a DATE
field and want to subtract 4 weeks.

SELECT [...]
FROM table
WHERE datefield >= '2002-08-19' - interval '4 weeks'


Kind regards
... Ralph ...

pgsql-general by date:

Previous
From: Joel Rees
Date:
Subject: Re: postgresql euc/sjis utf8 mappings
Next
From: "Peter Gibbs"
Date:
Subject: Re: DATE field subtraction