CEIL

The CEIL function returns the smallest whole number greater than or equal to a specified number.

Return Value

NUMBER

Syntax

CEIL(n)

Arguments

n

A whole number (NUMBER datatype) that you specify.

Examples

Example 10-43 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
    
  • The statement

    SHOW CEIL(-6.457)
    

    produces the following result.

    -6