FLOOR
Rounds a number down to the next lowest integer.
Syntax
FLOOR ( expression )
Arguments
expression: any valid numeric expression.
Return Type
Integer.
Examples
SELECT FLOOR(98.6), FLOOR(-98.6); **** +-------------+--------------+ | FLOOR(98.6) | FLOOR(-98.6) | +-------------+--------------+ | 98 | -99 | +-------------+--------------+