Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the smallest integer that is greater than or equal to a numeric expression.
Syntax
CEILING(numeric_expression)
Arguments
numeric_expression
Is a valid numeric expression.
Result Types
The data type of the numeric expression submitted to the function.
Remarks
CEILING returns a null result if the argument is null.
Expression Examples
These examples apply the CEILING function to positive, negative, and zero values.
CEILING(123.74)
Returns 124.00
CEILING(-124.27)
Returns -124.00
CEILING(0.00)
Returns 0.00