current_timestamp - 20 minutes

From: Matthew Terenzio <matt(at)jobsforge(dot)com>
To: PgSQL General <pgsql-general(at)postgresql(dot)org>
Subject: current_timestamp - 20 minutes
Date: 2005-07-13 03:30:23
Message-ID: df560b89977868913d4ddd9365c8191f@jobsforge.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I 'm storing things in a table with now() and I want to select * from
theTable WHERE the Timestamp is > the current time - 20 minutes

Anyone know the correct syntax. I was trying something like:

WHERE timestamp_field > (timestamp now() - interval '20 minutes')

and will continue reading the manual

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-07-13 03:43:32 Re: current_timestamp - 20 minutes
Previous Message Stuart Bishop 2005-07-13 02:18:35 Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea