MySQL CEIL() function

CEIL() function

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

This function is useful in -

• CEIL() is essential when you need to obtain the smallest integer that is greater than or equal to a given number.
• CEIL() ensures that you get the next highest integer.
• CEIL() is crucial when dealing with boundary conditions or limits where you need to ensure that a value falls on or above a certain threshold.
• In finance and accounting, CEIL() is used when dealing with monetary values, ensuring that rounding up is applied consistently.
• In inventory management systems, CEIL() can be used to round up quantities to ensure that enough stock is available for orders.
• In certain statistical calculations and simulations, CEIL() may be used to ensure that whole numbers are used in the analysis.

Syntax:

CEIL(N);

Argument:

Syntax Diagram:

MySQL Version: 8.0

Pictorial presentation of CEIL() Function

Example:

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

Code:

SELECT CEIL(2.2536);

Output:

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

Example : CEIL() function with negative value

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

Code:

SELECT CEIL(-2.2536);

Output:

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

Comparing between CEIL() function and FLOOR() function

All Mathematical Functions

Previous:ATAN()
Next: CEILING()