CEILING()

Class

Numeric Data

Purpose

Function to return the smallest integer that is greater than or equal to a given value

Syntax

CEILING(<expN>)

See Also

BETWEEN(), FLOOR(), ISDIGIT(), MAX(), MIN(), SIGN()

Description

The CEILING() function is used to return the smallest integer that is greater than or equal to a given value in the numeric expression <expN>.

Example

? ceiling(354.89)
       355
? ceiling(354.19)
       355
? ceiling(-354.89)
      -354

Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer