w3resource
MYSQL Tutorial

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

Name Description
N A number.

Syntax Diagram:

MySQL CEILING() Function - 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

MySQL Mathematical Functions, slide presentation

Previous: CEIL()
Next: CONV()