Navigation:  »No topics above this level«

CEILING()

Advantage Concepts

Return to chapter overview

Scalar function to compute the integer ceiling of a number.

Supported in SQL:

Yes

Supported in Navigational:

Yes

Syntax

CEILING( <nValue> ) à nInteger

Parameters

<nValue>

Floating point value

Return Value

The ceiling of <nValue>

Remarks

CEILING returns the smallest integer greater than or equal to <nValue>. In SQL usage, he return value is of the same data type as the input parameter.  In navigational usage, the result is a double floating point value.

See Also

Math Functions

FLOOR()