time comparing

From: Remigiusz Sokolowski <rems(at)gdansk(dot)sprint(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: time comparing
Date: 1999-03-09 12:48:42
Message-ID: Pine.GS4.4.02A.9903091346061.5490-100000@netra.gdansk.sprint.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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?
TIA
Rem

-------------------------------------------------------------------*------------
Remigiusz Sokolowski e-mail: rems(at)gdansk(dot)sprint(dot)pl * *
-----------------------------------------------------------------*****----------

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Patrik Kudo 1999-03-09 12:54:22 Re: [SQL] time comparing
Previous Message Viorel Anghel 1999-03-08 20:48:06 unsubscribe pgsql-sql