Re: [PHP] Convert Hours to Decimal

On 17 October 2011 22:57, Don Wieland wrote: > select timediff(cast(out_1 as time), cast(in_1 as time)) tHours FROM > lm_tc_trans WHERE tc_trans_id = '42' Can you try ... SELECT CAST ( TIMEDIFF ( CAST(Out_1 A

[PHP] Convert Hours to Decimal

Hey Tim, I got a select string: select timediff(cast(out_1 as time), cast(in_1 as time)) tHours FROM lm_tc_trans WHERE tc_trans_id = '42' result = 08:45:00 How do i convert that to a FLOAT (5,2) = 8.75 or result = 08:15:00 How do i convert that to a FLOAT (5,2) = 8.25 Don Wieland --