CEIL and CEILING functions
The CEIL and CEILING numeric functions return the smallest integer equivalent of a decimal number.
Syntax
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.
For example:
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.