Re: Convert Hours to Decimal

On Mon, Oct 17, 2011 at 17:57, Don Wieland <donw@dwdataconcepts.com> 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/