> -----Original Message----- > From: parasane@xxxxxxxxx [mailto:parasane@xxxxxxxxx] On Behalf Of Daniel > Brown > Sent: Monday, October 17, 2011 3:06 PM > To: Don Wieland > Cc: php-general@xxxxxxxxxxxxx > Subject: Re: Convert Hours to Decimal > > 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 LOLercopter. I love your sass! I've even felt the burn on occasion, but it's always appreciated in my book. :) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
