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

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

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

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