Creating timestamps in queries?

From: "Rob S(dot)" <rslifka(at)home(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Creating timestamps in queries?
Date: 2000-07-11 05:26:38
Message-ID: 001c01bfeaf8$96812be0$39117118@rct1.bc.wave.home.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Patrik Kudo 2000-07-11 07:07:44 Re: Creating timestamps in queries?
Previous Message Erol Oz 2000-07-11 00:50:33 Re: Finding entries not in table..differnce?