showing records from the last 20 min - Mailing list pgsql-sql

From Matthew Nuzum
Subject showing records from the last 20 min
Date
Msg-id 1048010456.1151.105.camel@localhost.localdomain
Whole thread Raw
Responses Re: showing records from the last 20 min  (Tomasz Myrta <jasiek@klaster.net>)
List 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@bearfruit.org
www.bearfruit.org



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: outer join versus not exists
Next
From: Tomasz Myrta
Date:
Subject: Re: showing records from the last 20 min