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