| description |
|---|
Returns the nearest equal or larger value of the input expression. Can also be called using CEIL(). |
- numeric_expression: The number (
DOUBLE,FLOAT,INTEGER) to compute the ceiling.
Examples
{% code title="CEILING example" %}
SELECT CEILING(3.1459)
-- 4{% endcode %}
{% code title="CEILING example" %}
SELECT CEIL(37.775420706711)
-- 38{% endcode %}
{% code title="CEILING example" %}
SELECT CEIL(-37.775420706711)
-- -37{% endcode %}
{% code title="CEILING example" %}
SELECT CEIL(0)
-- 0{% endcode %}