time intervals

From: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>
To: "'pgsql-sql(at)hub(dot)org'" <pgsql-sql(at)hub(dot)org>
Subject: time intervals
Date: 1999-04-29 20:13:21
Message-ID: 01BE925B.352BE160.jt-kirkpatrick@mpsllc.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Chris Bitmead 1999-04-30 00:06:27 Re: [SQL] Limit Questions 2
Previous Message JT Kirkpatrick 1999-04-29 18:52:40 why i couldn't insert. . .