SyntaxFix
Write A Post
Hire A Developer
Questions
SUBSTR will be better than FLOOR in some cases because FLOOR has a "bug" as follow:
SUBSTR
FLOOR
SELECT 25 * 9.54 + 0.5 -> 239.00 SELECT FLOOR(25 * 9.54 + 0.5) -> 238 (oops!) SELECT SUBSTR((25*9.54+0.5),1,LOCATE('.',(25*9.54+0.5)) - 1) -> 239