$ value doesnt round.

Question

my table doesnt round money values on the cents. It keeps showing multiple zeros after period. what could be wrong?

Answer 1

use round () function to round figure the numerical values.. for more information please write your query here

Answer 2

Some weird stuff can happen when doing operations on floats that results in a rounding error.

Answer 3

moreover...use double data type or curency and avoid float.

Answer 4

Have a look at http://dev.mysql.com/doc/refman/5.7/en/floating-point-types.html