Yes your right - I thought the numbers in the DB were something else.
__________________________________
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_________________________________
On Apr 2, 2004, at 11:11 AM, Paul DuBois wrote:
At 10:44 -0600 4/2/04, Craig Hoffman wrote:
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]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
