that worked - Thanks a bunch!
CH
__
Craig Hoffman - eClimb Media
v: (847) 644 - 8914
f: (847) 866 - 1946
e: [EMAIL PROTECTED]
w: www.eclimb.net
_
On Apr 11, 2004, at 3:14 PM, Mike Blezien wrote:
I think your looking for the ROUND(N,D)
I think your looking for the ROUND(N,D) function, IE:
select round('3.4285714285714',2) as miles;
3.43 miles
MikeBlezien
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Thunder Rain Internet Publishing
Providing Internet Solutions that work!
http://www.thunder-rain.com
Quality Web Hosting
http://www.jus
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 TURNCA
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 1
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
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 t
