Hi there, I have this query (see below)
SELECT SUM(distance + date), DATE_FORMAT(time_upload, '%M') FROM traininglog_client, users WHERE username='$username' AND DATE_SUB(CURDATE(),INTERVAL 1 MONTH) <= time_upload AND users.user_id = traininglog_client.user_id GROUP BY username
and it returns this: (see below)
SUM( distance + date ) DATE_FORMAT( time_upload, '%M' ) 140282467.4 March
How can I make the 140282467.4 into a more "readable" number? Such as 14.54.
Huh? How can 140282467.4 become 14.54?
-- Paul DuBois, MySQL Documentation Team Madison, Wisconsin, USA MySQL AB, www.mysql.com
MySQL Users Conference: April 14-16, 2004 http://www.mysql.com/uc2004/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
