Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Returns the ceiling of a number.
CEILING( numeric-expression )
numeric-expression The number whose ceiling is to be calculated.
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.
SQL/2003 Vendor extension.
The following statement returns the value 60.
SELECT CEILING( 59.84567 );