The same SQL,but I get different results。There is extra value “.0”，how to solve it？
Hi,
You are getting a ".0" because of the floor return the result in Double data type which when toString() will add ".0" to it. You can use CAST(FLOOR(SUM(c_field)) as UNSIGNED) in your query to force it to return in Integer data type.
Thanks,the floor looks like return integer. There I found reasons,maybe datalist results will change all fields to String. CONCAT(FLOOR(sum(c_planPayInterest))) works!
And when Joget V6 Beta3 release?
