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$ (view raw, whole thread or download thread mbox)
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


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-2017 The PostgreSQL Global Development Group