peterjc Posted September 10, 2007 Share Posted September 10, 2007 I have a problem here. When i try to sum the float number, I does not get accurate answer. For example: 20.5 + 10.8 = 31.3 (This is correct) But if i use the Mysql Sum function to sum the two number, the answer is inaccurate, just for example, you may get 31.300000054 What is the problem and how to solve this problem? thank Link to comment https://forums.phpfreaks.com/topic/68664-sum-mysql-float-datatype/ Share on other sites More sharing options...
Illusion Posted September 10, 2007 Share Posted September 10, 2007 ROUND() Link to comment https://forums.phpfreaks.com/topic/68664-sum-mysql-float-datatype/#findComment-345253 Share on other sites More sharing options...
peterjc Posted September 11, 2007 Author Share Posted September 11, 2007 Illusion, could you please explain it a bit more details about the "ROUND()"? i am a new the this actually so do not understand so much. Thank you Link to comment https://forums.phpfreaks.com/topic/68664-sum-mysql-float-datatype/#findComment-345730 Share on other sites More sharing options...
Illusion Posted September 11, 2007 Share Posted September 11, 2007 select ROUND(SUM(20.5 + 10.,1) ; the second argument for ROUND function is the no of decimal places. Link to comment https://forums.phpfreaks.com/topic/68664-sum-mysql-float-datatype/#findComment-345836 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.