| --- |
| { |
| "title": "CEIL", |
| "language": "en" |
| } |
| --- |
| |
| ## ceil |
| |
| ### description |
| #### Syntax |
| |
| `BIGINT ceil(DOUBLE x)` |
| Returns the smallest integer value greater than or equal to `x`. |
| |
| :::tip |
| The other alias for this function are `dceil` and `ceiling`. |
| ::: |
| |
| ### example |
| |
| ``` |
| mysql> select ceil(1); |
| +-----------+ |
| | ceil(1.0) | |
| +-----------+ |
| | 1 | |
| +-----------+ |
| mysql> select ceil(2.4); |
| +-----------+ |
| | ceil(2.4) | |
| +-----------+ |
| | 3 | |
| +-----------+ |
| mysql> select ceil(-10.3); |
| +-------------+ |
| | ceil(-10.3) | |
| +-------------+ |
| | -10 | |
| +-------------+ |
| ``` |
| |
| ### keywords |
| CEIL, DCEIL, CEILING |
