CEILING

CEILING() is a synonym for CEIL().

Rounds the number up.

Syntax

CEILING(x)

Arguments

Arguments	Description
x	The numerical value.

Return Type

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

Examples

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

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