CEIL or CEILING function

The returned value is the smallest (closest to negative infinity) double floating point value that is greater than or equal to the specified number. The returned value is equal to a mathematical integer. The data type of the returned value is a DOUBLE PRECISION number.

If the specified number is less than zero but greater than -1.0, then the result of these functions is zero.

If the specified number is zero (0), the result of these functions is zero.

If the specified number is NULL, the result of these functions is NULL.

The CEIL and CEILING functions round the specified number up, and return the smallest number that is greater than or equal to the specified number.

The specified number must be aDOUBLE PRECISIONnumber.

If the specified number is equal to a mathematical integer, the result of these functions is the same as the specified number.

CEIL or CEILING function

Leave a Comment