CEILING
Returns the nearest equal or larger value of the input expression. Can also be called using CEIL().
Syntax
CEILING(numeric_expression NUMERIC) → INTEGER
numeric_expression: The number (
DOUBLE
,FLOAT
,INTEGER
) to compute the ceiling.
Examples
SELECT CEILING(3.1459)
-- 4
SELECT CEIL(37.775420706711)
-- 38
SELECT CEIL(-37.775420706711)
-- -37
SELECT CEIL(0)
-- 0
Last updated
Was this helpful?