CEILING(X)

Returns the smallest integer value not less than X. Returns NULL if X is NULL.

Syntax

MYSQL Copy

SELECT CEILING(1.23);
2
SELECT CEILING(-1.23);
-1

Examples

Example

For exact-value numeric arguments, the return value has an exact-value numeric type. For string or floating-point arguments, the return value has a floating-point type.

MYSQL Copy

SELECT CEILING(1.23);
2
SELECT CEILING(-1.23);
-1