CEILING()
This page is part of MariaDB's Documentation.
The parent of this page is: Functions for MariaDB Xpand
Topics on this page:
Overview
Returns the nearest integer value, rounding upwards.
USAGE
CEILING(number)
Argument Name | Description |
|---|---|
| The number to round |
DETAILS
CEILING() is a mathematical function that returns the nearest integer that is either equal to or higher than the input value. This is known as a "ceiling function".
A NULL is returned if the argument is NULL.
The data size of the return value depends on the data size of the argument.
EXAMPLES
CREATE TABLE ceiling_example (
example FLOAT
);
INSERT INTO ceiling_example VALUES
(1.1), (42.5), (99.9), (7.0), (-11.2);
SELECT example, CEILING(example)
FROM ceiling_example;
+---------+------------------+
| example | CEILING(example) |
+---------+------------------+
| 1.1 | 2 |
| 42.5 | 43 |
| 99.9 | 100 |
| 7 | 7 |
| -11.2 | -11 |
+---------+------------------+