Returns the first integer that is greater or equal to a given value. For positive numbers, this is known as rounding up.

Syntax

CEILING( numeric-expression )

Parameters

Returns

DOUBLE

Remarks

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

See also

• FLOOR function [Numeric]

Standards and compatibility

Example

The following statement returns the value 60.

SELECT CEILING( 59.84567 );