Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.1) with ESMTP id QAA27255 for ; Thu, 29 Apr 1999 16:11:22 -0400 (EDT) (envelope-from jt-kirkpatrick@mpsllc.com) Received: from kirkpatrickjt (whiteoak-34.highertech.net [209.140.56.34] (may be forged)) by s20.highertech.net (8.8.6/8.8.6) with SMTP id QAA04158 for ; Thu, 29 Apr 1999 16:10:31 -0400 Received: by localhost with Microsoft MAPI; Thu, 29 Apr 1999 16:13:24 -0400 Message-ID: <01BE925B.352BE160.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'pgsql-sql@hub.org'" Subject: time intervals Date: Thu, 29 Apr 1999 16:13:21 -0400 Organization: MPS, LLC X-Mailer: Microsoft Internet E-mail/MAPI - 8.0.0.4211 MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit I have two fields, timein & timeout, both defined as type "time". how can i get the difference between the two?? i am connecting to postgres through access97 and trying to run a simple query to show me timeout, timein, and timeout-timein, but the calculation is returning an error. thanks in advance! jt