Skip Headers
The CEIL function returns the smallest whole number greater than or equal to a specified number.
Return Value
NUMBER
Syntax
CEIL(n)
Arguments
A whole number (NUMBER datatype) that you specify.
Examples
Example 8-41 Displaying the Smallest Integer Greater Than or Equal to a Number
The following statements show results returned by CEIL.
The statement
SHOW CEIL(15.7)
produces the following result
16
SHOW CEIL(-6.457)
produces the following result.
-6
