Postgres Pro
Downloads
Home   >   mailing lists

time intervals - Mailing list pgsql-sql

From JT Kirkpatrick
Subject time intervals
Date
Msg-id 01BE925B.352BE160.jt-kirkpatrick@mpsllc.com
Whole thread Raw
Responses Re: [SQL] time intervals  (Mark Jewiss <mark@office.knowledge.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: JT Kirkpatrick
Date:
Subject: why i couldn't insert. . .
Next
From: Chris Bitmead
Date:
Subject: Re: [SQL] Limit Questions 2