Postgres Pro
Downloads
Home   >   mailing lists

Re: timestamp differences - Mailing list pgsql-general

From Adrian Klaver
Subject Re: timestamp differences
Date
Msg-id 200812281353.31139.aklaver@comcast.net
Whole thread Raw
In response to timestamp differences  (Garry Saddington <garry@schoolteachers.co.uk>)
Responses Re: timestamp differences  (Adrian Klaver <aklaver@comcast.net>)
List pgsql-general
Tree view 
On Sunday 28 December 2008 1:40:28 pm Garry Saddington wrote:
> I have a timestamp column that I want to compare with current timestamp.
> I want to get all rows that are less than 10 minutes old. I have searched
> but can not find how to do this, any pointers?
> regards
> Garry

select * from foo where ts_fld > now() - 'interval 10 min'

--
Adrian Klaver
aklaver@comcast.net

pgsql-general by date:

Previous
From: Garry Saddington
Date:
Subject: timestamp differences
Next
From: Adrian Klaver
Date:
Subject: Re: timestamp differences