Convert Hours to Decimal
| From: | Don Wieland | Date: | Mon, 17 Oct 2011 21:57:44 +0000 |
| Subject: | Convert Hours to Decimal | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-315337@lists.php.net to get a copy of this message | ||
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