d_dude_2003 wrote:

SELECT CAST(((T2.CHECKOUT_TIMESTAMP - T2.CHECKIN_TIMESTAMP)
* 24) AS INTEGER)

I use 1440 and get the minutes, but I'm sure it 'rounds down'

--
Lester Caine - G8HFL
-----------------------------
L.S.Caine Electronic Services
Treasurer - Firebird Foundation Inc.