TRUNCATE(SUM(), X) producing a slight output error

outputs for instance 7.59 instead of 7.60

[dbarasuk]

Hey,

I used the expression mentionned in the title to output a floating figure from a MySQL float column type . If the amount in the table is for instance 7.60 the expression produces 7.59 instead of 7.6O. The difference is very small but could become big on a sum done on a large number of values.

Any help on this?

Regards.
D.B

[kp2a]

You will always run into this problem with FLOAT. If you are dealing with money, always use INT and pennies for storing money.

[rocknbil]

Why wouldn't you use decimal?

It is now a numeric data type.

This (7.6 -> 7.59) is an artifact of floating point precision, you will find it in almost any type of programming (drives me nuts in Javascript.) Alternatively you can use the formatting tools in the language of your choice to correctly pad/truncate numbers.