On 17 October 2011 22:57, Don Wieland <donw@xxxxxxxxxxxxxxxxxx> 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 AS Time), CAST(In_1 AS Time) ) AS Decimal(5,2) ) tHours FROM lm_tc_trans WHERE tc_trans_id = '42' Basically, CAST the result back to a decimal(5,2) -- Richard Quadling Twitter : EE : Zend : PHPDoc : Fantasy Shopper @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY : bit.ly/lFnVea : fan.sh/6/370 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
