On Sunday 28 December 2008 1:53:30 pm Adrian Klaver wrote:
> 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
select * from foo where ts_fld > now() - interval '10 min'
In response to
pgsql-general by date
|Next:||From: Greg Smith||Date: 2008-12-28 22:04:47|
|Subject: Re: Bgwriter and pg_stat_bgwriter.buffers_clean aspects|
|Previous:||From: Adrian Klaver||Date: 2008-12-28 21:53:30|
|Subject: Re: timestamp differences|