CEIL

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

Return Value

NUMBER

Syntax

CEIL(n)

Parameters

n

A number (NUMBER data type) that you specify.

Examples

Example 7-38 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