Ralph Graulich wrote:> SELECT [...]> FROM table> WHERE datefield >= '2002-08-19' - interval '4 weeks'
There are probably shorter forms, but the full version would be: '2002-08-19'::date - '4 weeks'::interval-- Peter GibbsEmKel Systems