select round('3.4285714285714',2) as miles;
3.43 miles
Mike<mickalo>Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Quality Web Hosting http://www.justlightening.net MSN: [EMAIL PROTECTED] 1.985.320.1191 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Craig Hoffman wrote:
Hi There: I have a query where I get an average of weekly miles. For example:
Average Weekly Miles: 3.4285714285714
How would I get this number into a more read format? Such as 3.42. I have tried the truncate but I can't seem to get it to work. Does any one have any suggestions?
"SELECT TURNCATE(AVG(distance)), rest of the query ....
Thanks - CH __________________________________ Craig Hoffman - eClimb Media
v: (847) 644 - 8914 f: (847) 866 - 1946 e: [EMAIL PROTECTED] w: www.eclimb.net _________________________________
--
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
