Received: from s20.highertech.net (root@s20.highertech.net [209.54.120.20]) by hub.org (8.9.3/8.9.3) with ESMTP id JAA38077 for ; Fri, 30 Apr 1999 09:22:41 -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 JAA01364; Fri, 30 Apr 1999 09:21:16 -0400 Received: by localhost with Microsoft MAPI; Fri, 30 Apr 1999 09:24:09 -0400 Message-ID: <01BE92EB.33C3EA80.jt-kirkpatrick@mpsllc.com> From: JT Kirkpatrick To: "'George Moga'" Cc: "'pgsql-sql@hub.org'" Subject: RE: [SQL] time intervals Date: Fri, 30 Apr 1999 09:24:08 -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 george -- thanks! that worked fine! i was able to substitute my fields "timeout" and "timein" for the times you showed in quotes, and add a "where" condition to the select statement to choose a particular record. now i have to find a way to present it in access97, in a regular time format (1:35 - for 1hr 35mins) -- that or get rid of the "ago" which should be pretty easy! thanks so much for your help! jt -----Original Message----- From: George Moga [SMTP:george@flex.ro] Sent: Friday, April 30, 1999 5:53 AM To: JT Kirkpatrick; SQL PostgreSQL Subject: Re: [SQL] time intervals << File: ATT00000.html; charset = iso-8859-2 >>