Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-sql by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group