Hi,
I assume I am just to blind to find it in the documentation: I have a DATEfield and want to subtract 4 weeks.
SELECT [...]FROM tableWHERE datefield >= '2002-08-19' - interval '4 weeks'
Kind regards... Ralph ...