Received: from aquarius.asdev.activestrategy.com ([146.145.232.35]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f863TI784117 for ; Wed, 5 Sep 2001 23:29:18 -0400 (EDT) (envelope-from bmatzelle@yahoo.com) Received: from aquarius ([127.0.0.1]) by aquarius.asdev.activestrategy.com with Microsoft SMTPSVC(5.0.2195.2966); Wed, 5 Sep 2001 13:24:47 -0400 Date: Wed, 05 Sep 2001 13:24:47 -0400 To: pgsql-php@postgresql.org From: "Brent R. Matzelle" Subject: Date calc/comparisions X-Mailer: Opera 5.12 build 932 X-Priority: 3 (Normal) Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Message-ID: X-OriginalArrivalTime: 05 Sep 2001 17:24:47.0637 (UTC) FILETIME=[A9644C50:01C1362F] X-Archive-Number: 200109/1 X-Sequence-Number: 522 I need to know if the date returned from a TIMESTAMP field is less than 24 hours old. However, PHP does not understand how to compare times retrieved from PostgreSQL. Have any of you any experience with this type of calculation? Thanks and warm regards, Brent