Re: [SQL] Subtracting time fields

2002-11-01 Thread Bruno Wolff III
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

[SQL] Subtracting time fields

2002-11-01 Thread Kevin Old
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(releas