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

Re: Creating timestamps in queries?

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: "Rob S(dot)" <rslifka(at)home(dot)com>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Creating timestamps in queries?
Date: 2000-07-11 07:07:44
Message-ID: Pine.BSF.4.21.0007110906450.27659-100000@tb303.partitur.se (view raw or flat)
Thread:
Lists: pgsql-sql
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?


In response to

pgsql-sql by date

Next:From: Adam WalczykiewiczDate: 2000-07-11 07:16:19
Subject: SQL-92 SQLSTATE in PostgreSQL ?!
Previous:From: Rob S.Date: 2000-07-11 05:26:38
Subject: Creating timestamps in queries?

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