CEIL, CEILING
Returns the smallest integer value that is greater than or equal to <value>.
Syntax
CEIL(<value>);
OR
CEILING(<value>);
| Parameter | Description | Supported input types |
|---|---|---|
<value> | Valid values include column names, functions that return a column with numeric values, and constant numeric values. | Any of the numeric data types |
Return Types
Same as the input datatype (<value>).
Remarks
When the input is of type NUMERIC, this function throws an overflow error if the result does not fit into the return type.
For example:
SELECT
CEIL('99.99'::NUMERIC(4,2));
returns: OVERFLOW ERROR, because CEIL will produce the value 100, but it can not fit into the NUMERIC type with only 2 whole digits.
Examples
SELECT
CEIL(2.5549900);
Returns: 3
SELECT
CEIL('213.1549'::NUMERIC(20,4));
Returns: 214.0000