FLOOR

Description

Returns the largest integer less than or equal to the specified number.

Syntax

FLOOR(num) -> Decimal

Parameters

ParameterData TypeRequiredDescription
numDecimalYesThe value or numeric field to round down.

Examples

FLOOR(1.2)
--Returns 1.
FLOOR(-1.2)
--Returns -2.