On Thu, 2006-02-23 at 13:55, Brandon Metcalf wrote:
> 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);
Tell it you're subracting a minute:
select now() - interval '13 minutes';
That kind of thing