4.9.2.10 CEILING function (ODBC compatible)

Syntax

CEILING ( expression )

Description

The scalar function CEILING returns the smallest integer greater than or equal to expression.

Example

SELECT CEILING (32.5) 'Ceiling'
     FROM SYSTPE.SYSCALCTABLE;

Notes

• expression must evaluate to a numeric data type.