I think you meant: select * from blah where stamp >= now() - '7days'::interval; You can also try: select * from blah where age( now(), stamp ) < '7days'::interval; Frank At 09:07 AM 7/11/00 +0200, you wrote: >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? > > >
