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
(
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
