---

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