Re: Subtracting time fields - Mailing list pgsql-sql

From Bruno Wolff III
Subject Re: Subtracting time fields
Date
Msg-id 20021101223054.GA2474@wolff.to
Whole thread Raw
In response to Subtracting time fields  (Kevin Old <kold@carolina.rr.com>)
List pgsql-sql
On Fri, Nov 01, 2002 at 17:05:26 -0500, Kevin Old <kold@carolina.rr.com> wrote:
> Hello all,
> 
> I have two fields in my database access_time and release_time.....I
> would like to calculate the "duration" between these two values, but
> can't figure out what to do.  
> 
> I've tried something like this but it doesn't work:
> 
> select access_time, release_time, time(access_time) - time(release_time)
> as duration from mastertbl limit 10

You should be able to just subtract release_time from access_time without
trying to call the time function. The type of the difference will be
an interval.


pgsql-sql by date:

Previous
From: Robert Treat
Date:
Subject: Re: HA PostgreSQL
Next
From: Josh Berkus
Date:
Subject: Re: making queries more effecient