1 of 1

CEILING

Round up to the nearest integer. This function returns the smallest integer value that is greater than or equal to the argument.

Syntax

CEILING(X)

Description

Returns the smallest integer value not less than X.

Examples

_{This page is licensed: GPLv2, originally from}

SELECT CEILING(1.23);
+---------------+
| CEILING(1.23) |
+---------------+
|             2 |
+---------------+

SELECT CEILING(-1.23);
+----------------+
| CEILING(-1.23) |
+----------------+
|             -1 |
+----------------+