Re: [SQL] time comparing - Mailing list pgsql-sql

From Patrik Kudo
Subject Re: [SQL] time comparing
Date
Msg-id 36E519FE.935BE019@partitur.se
Whole thread Raw
In response to time comparing  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
Responses Re: [SQL] time comparing  (Remigiusz Sokolowski <rems@gdansk.sprint.pl>)
List pgsql-sql
Remigiusz Sokolowski wrote:
>
> hi!
> I need to compare two values of time.
> One of them is just value of field - I want to compare it to value of
> now() less 1 hour - shortly I want to select all records which are older
> then 1 hour - how to do that?

Ah! This reminds me! I've been wondering about a similar problem. How do
I
exchange that 1 hour with one week or one month? Probably the same way
as
with one hour (if there is any easy way)...

Regards,
Patrik Kudo

pgsql-sql by date:

Previous
From: Remigiusz Sokolowski
Date:
Subject: time comparing
Next
From: Remigiusz Sokolowski
Date:
Subject: Re: [SQL] time comparing