subtracting minutes from date

From: "Brandon Metcalf" <bmetcalf(at)nortel(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: subtracting minutes from date
Date: 2006-02-23 19:55:34
Message-ID: Pine.LNX.4.58L.0602231350270.30715@cash.rhiamet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

What is the best way to store a timestamp if all I need to do is
select rows where this timestamp is less than 60 minutes prior to the
current time?

If I have a column called date with data type timestamp without time
zone I know I can use

SELECT * FROM table WHERE date < (now()::DATE - 7)::TIMESTAMP;

to select rows where date is older than seven days. I'm not quite
sure how to interpret now()::DATE::TIMESTAMP since I'm not able to
answer my own question. I've tried things like:

SELECT * FROM table WHERE date < now()::DATE::(TIMESTAMP - 60);

but this gives a syntax error.

Thanks.

--
Brandon

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Henrique Reimer 2006-02-23 20:12:39 Is the pg_locks been used?
Previous Message Martijn van Oosterhout 2006-02-23 19:55:27 Re: Limitations : Number of ...