Query_Lang-SystemFunctions_Arithmetic_FLOORFLOOR_AD
Created: September 05, 2015 | Updated: August 12, 2021
| Applies to versions: 15.1, 16.0, 16.1, 17.0, 17.1, 18.0, 18.1, 19.0, 19.1, 20.0, 20.1 and 20.2
Now reading version 20.0. For the latest, read: Query_Lang-SystemFunctions_Arithmetic_FLOOR((FLOOR))_AD for version 21
Parent page: System Query Functions - Arithmetic Functions
Summary
Returns an integral number, whose value depends upon the nature of the parameter's numeric value. If that numeric value is an exact integer, the number returned has exactly the same value; otherwise the number returned is the largest integer that is smaller in value than the parameter's numeric value.
Syntax
FLOOR(X : Number / Numeric_String) : Number
Example Usage
FLOOR(5.0)
Returns 5.
FLOOR(5.33)
Returns 5.
FLOOR(-5.0)
Returns -5.
FLOOR(-5.33)
Returns -6.