FLOOR

Returns the greatest integer that is less than or equal to the value of a number or numeric expression.

Note:  This function is equivalent to FLOOR in T-SQL.

Return Value

Integer

Syntax

FLOOR( numExpr )

where numExpr is a number or an expression that resolves to a numeric value.