MySQL CEILING() function

CEILING() function

MySQL CEILING() returns the smallest integer value not less than the number specified as an argument. The synonym of CEILING() is CEIL().

Syntax:

CEILING(N);

Argument:

Syntax Diagram:

MySQL Version: 5.6

Example:

Code:

SELECT CEILING(2.2536);

Explanation:

The above MySQL statement returns 3 which is the smallest integer value not less than the value specified (2.2536) in the argument.

Sample Output:

mysql> SELECT CEILING(2.2536);
+-----------------+
| CEILING(2.2536) |
+-----------------+
|               3 | 
+-----------------+
1 row in set (0.00 sec)

All Mathematical Functions

Previous:CEIL()
Next: CONV()