MySQL CEIL() Function
Multi tool use
Clash Royale CLAN TAG#URR8PPP
<!--
main_leaderboard, all: [728,90][970,90][320,50][468,60]-->
MySQL CEIL() Function
❮ MySQL Functions
Example
Return the smallest integer value that is greater than or equal to 25.75:
SELECT CEIL(25.75);Try it Yourself »
Definition and Usage
The CEIL() function returns the smallest integer value that is bigger than or
equal to a number.
Note: This function is equal to the
CEILING()
function.
Syntax
CEIL(number)Parameter Values
| Parameter | Description |
|---|---|
| number | Required. A numeric value |
Technical Details
| Works in: | From MySQL 4.0 |
|---|
More Examples
Example
Return the smallest integer value that is greater than or equal to 25:
SELECT CEIL(25);Try it Yourself »
❮ MySQL Functions
