CEILING()

From Lianjapedia
Jump to: navigation, search

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