showing records from the last 20 min

From: Matthew Nuzum <cobalt(at)bearfruit(dot)org>
To: Postgres SQL <pgsql-sql(at)postgresql(dot)org>
Subject: showing records from the last 20 min
Date: 2003-03-18 18:00:56
Message-ID: 1048010456.1151.105.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

I know this is such a simple question, but I can't find the answer in
the manual and I've tried very hard to find it.

I want to show all the records in a table that occurred in the last 20
min.

So, maybe something like:
select * from sys_logins WHERE tstamp >= now() - '00:20';

on pg 7.3.2 this produces the error:
ERROR: Bad timestamp external representation '00:20'

Thanks for any help,
--
Matthew Nuzum
cobalt(at)bearfruit(dot)org
www.bearfruit.org

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tomasz Myrta 2003-03-18 18:19:50 Re: showing records from the last 20 min
Previous Message Bruno Wolff III 2003-03-18 17:30:55 Re: outer join versus not exists