Re: [SQL] time comparing

From: Patrik Kudo <kudo(at)partitur(dot)se>
To: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
Cc: pgsql-sql(at)postgreSQL(dot)org
Subject: Re: [SQL] time comparing
Date: 1999-03-09 12:54:22
Message-ID: 36E519FE.935BE019@partitur.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Remigiusz Sokolowski 1999-03-09 13:09:00 Re: [SQL] time comparing
Previous Message Remigiusz Sokolowski 1999-03-09 12:48:42 time comparing