On Fri, Nov 01, 2002 at 17:05:26 -0500,
Kevin Old <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
