CEIL

ceil(expr [, d])

Description

The CEIL function is used to return the result of rounding up the numeric parameter expr to the nearest decimal place at the d-th position after the decimal point. When d is negative, it means rounding to the left of the decimal point.

Parameter Description

• expr: The numeric parameter that needs to be rounded up. It can be of type float, double, tinyint, smallint, int, or bigint. The current version does not support the decimal type.
• d: Optional parameter that indicates the number of decimal places to retain. The default value is 0, which means no decimal places are retained. d can be a positive or negative number.

Return Result

Returns a value of the same type as expr.

Usage Example

-- Returns the result of rounding up -0.1 SELECT ceil(-0.1); -- Result: 0 -- Returns the result of rounding up 5 SELECT ceil(5); -- Result: 5 -- Returns the result of rounding up 5123.123 to one decimal place SELECT ceil(5123.123, 1); -- Result: 5123.2 -- Returns the result of rounding up 5123.123 to one place to the left of the decimal SELECT ceil(5123.123, -1); -- Result: 5130 -- Returns the result of rounding up 12345.6789 to two decimal places SELECT ceil(12345.6789, 2); -- Result: 12345.68 -- Returns the result of rounding up -123.456 to three decimal places SELECT ceil(-123.456, 3); -- Result: -123.456 -- Returns the result of rounding up 0 to two decimal places SELECT ceil(0, 2); -- Result: 0

Notes

• When d is a non-integer, it will automatically be rounded down to the nearest integer.
• When d is 0, the CEIL function will return the integer part, and the decimal part will be discarded.
• When expr is negative, the CEIL function will return a smaller negative result.