MySql Integer to Floating Point Expression

Question

I want to echo out a FLOAT value like when i used my calculator but the output is an integer. how to get the float output?

Explanation below :

here are the values :

user_rate=350
user_overtime=3


user_rate/8*user_overtime AS overtimetotal

current output is  = 131
expected output is = 131.25

Mitch Wheat · Accepted Answer · 2014-10-27 23:09:13Z

5

You are performing integer arithmetic (which results in truncation of the float part). Instead use:

user_rate/8.0 * user_overtime AS overtimetotal

this will promote your expression to floating point.

answered Oct 27, 2014 at 22:53

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1