Contact Us
Contact our corporate or local offices directly.
Parent page: System Query Functions - Arithmetic Functions
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.
FLOOR(X : Number / Numeric_String) : Number
FLOOR(5.0)
Returns 5.
FLOOR(5.33)
Returns 5.
FLOOR(-5.0)
Returns -5.
FLOOR(-5.33)
Returns -6.
Contact our corporate or local offices directly.