Hello, I have a table bill like when (date), how_much (float), what (varchar).
Now I store some bills on it - how_much will get numbers with 2 digits after point.
Then I want to know how much money I spent each month.
SELECT SUM(how_much), YEAR(when), MONTH(when) FROM bill GROUP BY (YEAR(when)*12+MONTH(when))
I expect to get numbers with not more than 2 digits after the point. Surprisingly I get ??.259999978 when I expect to get ??.26 or some else strange numbers.
Where is my mistake ?? I already googel-t and browsed the archive, no success.
Thanks,
Adib.
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]