Round down | MATH_FLOOR
Syntax
MATH_FLOOR( [value] )
Parameters
value
A number.
If the value is not a NUMBER, the FLOAT operation will be used to convert it.
Return Value
Returns a number.Description
Returns the nearest integer that is less than or equal to a given number.Examples
MATH_FLOOR(-16.3) # returns -17
MATH_FLOOR(16.7) # returns 16
MATH_FLOOR(null) # returns 0
MATH_FLOOR("-21.7") # returns -22