Postgres Pro
Downloads
Home   >   mailing lists

Creating timestamps in queries? - Mailing list pgsql-sql

From Rob S.
Subject Creating timestamps in queries?
Date
Msg-id 001c01bfeaf8$96812be0$39117118@rct1.bc.wave.home.com
Whole thread Raw
Responses Re: Creating timestamps in queries?  (Patrik Kudo <kudo@partitur.se>)
List pgsql-sql
Tree view 
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?

TIA! =)

- Rob Slifka

pgsql-sql by date:

Previous
From: Erol Oz
Date:
Subject: Re: Finding entries not in table..differnce?
Next
From: Patrik Kudo
Date:
Subject: Re: Creating timestamps in queries?