Function group: numeric function
CEILING() (“round up to the ceiling”) determines the smallest integer which is greater than or equal to the specified numeric value. In the case of non-integer numeric values, CEILING() always rounds up.
CEIL[ING] ( expression )
expression
Fixed-point value of the type NUMERIC(p,s) or DECIMAL(p,s) if the number of decimal places s is greater than 0, otherwise a numeric expression.
expression may not be a multiple value with dimension > 1.
Result
When expression returns the NULL value, the result is the NULL value.
Otherwise:
The smallest integer which is greater than the specified numeric value.
Data type: NUMERIC(q+1,0) or DECIMAL(q+1,0) where q=MIN(31,p+1) if the number of decimal places s is greater than 0, otherwise like expression.
Examples
CEILING (3,14) returns the value 4.
CEILING (-3,14) returns the value -3.
CEILING (10,14) returns the value 11.