w3resource

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()



Follow us on Facebook and Twitter for latest update.




We are closing our Disqus commenting system for some maintenanace issues. You may write to us at reach[at]yahoo[dot]com or visit us at Facebook