ceil, dceil
Returns values from the input arg
rounded to the nearest equal or larger integer.
Syntaxβ
ceil(arg)
Parameterβ
arg
supports the DOUBLE data type.
Return valueβ
Returns a value of the BIGINT data type.
Examplesβ
mysql> select ceil(3.14);
+------------+
| ceil(3.14) |
+------------+
| 4 |
+------------+
1 row in set (0.15 sec)