Hi Rob, Try this: select * from blah where stamp >= now()::date - 7; I think it should work. /Patrik Kudo On Mon, 10 Jul 2000, Rob S. wrote: > Hi all, > > I would like to say, > > "select * from blah where stamp >= 7 days ago" > > ...where the "days ago" is calculated at query time; meaning that its not > hardcoded into the query as a date string. Is this possible?
