The CEIL and CEILING numeric functions return the smallest integer equivalent of a decimal number.
CEIL and CEILING return the smallest integer value greater than or equal to source_number. The parameter can be any numeric data type. The result is of the same type as the parameter unless it is NULL, in which case the result is NULL.
CEIL(1)returns 1
CEIL(1.2)returns 2.0
CEIL(-1.2)returns -1.0
If possible, the scale is changed to zero. If the result cannot be represented at that scale, it is made sufficiently large to represent the number.