CEILING / CEIL
Calculates the smallest integer greater than the numeric expression given.
Syntax
CEILING( expr )
CEIL ( expr )
Arguments
Parameter |
Description |
---|---|
|
Numeric expression |
Returns
When using the CEILING
and CEIL
floating point number scalar functions, real
arguments are automatically cast to double
precision.
Notes
If the input value is NULL, the result is NULL.
Examples
FLOOR vs. CEIL
vs. ROUND
numbers=> SELECT FLOOR(x), CEIL(x), ROUND(x)
. FROM (VALUES (0.0001), (-0.0001)
. , (PI()), (-2.718281), (500.1234)) as t(x);
floor | ceil | round
------+------+------
0 | 1 | -0
3 | 4 | 3
-3 | -2 | -3
500 | 501 | 500