current_timestamp - 20 minutes - Mailing list pgsql-general

From Matthew Terenzio
Subject current_timestamp - 20 minutes
Date
Msg-id df560b89977868913d4ddd9365c8191f@jobsforge.com
Whole thread Raw
Responses Re: current_timestamp - 20 minutes
List 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


pgsql-general by date:

Previous
From: Stuart Bishop
Date:
Subject: Re: PL/pgGRESQL, SHA, BYTEA - Creating SHA1 hash for Bytea
Next
From: "Joshua D. Drake"
Date:
Subject: Re: current_timestamp - 20 minutes