Postgres Pro
Downloads
Home   >   mailing lists

time comparing - Mailing list pgsql-sql

From Remigiusz Sokolowski
Subject time comparing
Date
Msg-id Pine.GS4.4.02A.9903091346061.5490-100000@netra.gdansk.sprint.pl
Whole thread Raw
List pgsql-sql
Tree view 
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@gdansk.sprint.pl           * *
-----------------------------------------------------------------*****----------

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [SQL] 6.4.x vs. 6.5 oddity
Next
From: Patrik Kudo
Date:
Subject: Re: [SQL] time comparing