Query_Lang-SystemFunctions_Arithmetic_CEILCEIL_AD
Created: 八月 02, 2022 | Updated: 八月 02, 2022
| Applies to version: 4
This document is no longer available beyond version 4. Information can now be found here: CEIL for version 5
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 smallest integer that is larger in value than the parameter's numeric value.
Syntax
CEIL(X : Number / Numeric_String) : Number
Example Usage
CEIL(5.0)
Returns 5.
CEIL(5.33)
Returns 6.
CEIL(-5.0)
Returns -5.
CEIL(-5.33)
Returns -5.