Categories: Numeric

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) for which you want to compute the ceiling.

Examples

SELECT CEILING(3.1459)
-- 4
SELECT CEIL(37.775420706711)
-- 38
SELECT CEIL(-37.775420706711)
-- -37
SELECT CEIL(0)
-- 0