Returns the ceiling of a number.

Syntax

CEILING( numeric-expression )

Parameters

Remarks

The CEILING function returns the first integer that is greater or equal to a given value. For positive numbers, this is also known as rounding up.

This function converts its argument to DOUBLE, performs the computation in double-precision floating point, and returns a DOUBLE as the result.

See also

• FLOOR function [Numeric]

Standards and compatibility

Example

The following statement returns the value 60.

SELECT CEILING( 59.84567 );