跳到主要内容

CEIL

Rounds the number up.

Syntax

CEIL(x)

Arguments

ArgumentsDescription
xThe numerical value.

Return Type

A numeric data type value which is the same as input type.

Examples

SELECT CEIL(1.23), typeof(ceil(3)), typeof(ceil(5.3));
+------------+------------------+-------------------+
| CEIL(1.23) | typeof(ceil(3)) | typeof(ceil(5.3)) |
+------------+------------------+-------------------+
| 2.0 | TINYINT UNSIGNED | DOUBLE |
+------------+------------------+-------------------+

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