On Mon, Oct 17, 2011 at 17:57, Don Wieland <donw@xxxxxxxxxxxxxxxxxx> wrote:
> 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
It's been a while since folks here have been pushing the acronyms
that used to be the norm on this list: GIYF, RTFM, et cetera. So you
get to be the lucky example, Don: Google Is Your Friend.
http://tinyurl.com/3snzw52
That quick term then brings up:
http://www.hashbangcode.com/blog/converting-and-decimal-time-php-522.html
--
</Daniel P. Brown>
Network Infrastructure Manager
http://www.php.net/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
