Re: [PHP] Convert Hours to Decimal

2011-10-27 Thread Richard Quadling
On 17 October 2011 22:57, Don Wieland d...@dwdataconcepts.com 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 (

[PHP] Convert Hours to Decimal

2011-10-17 Thread Don Wieland
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 --