floor

Returns the greatest integer less than or equal to x.

Syntax

floor(x)

Parameters

x can be any of the following data types:
long, money, or double.

Examples

• floor(1.4) = 1
• floor(1.6) = 1
• floor(-1.4) = -2
• floor(-1.6) = -2

Related links

• Use functions in custom columns
• round
• ceiling