📣
TiDB Cloud Premium is now in public preview. Unlimited growth, instant elasticity, advanced security for enterprise workloads. Try it out →

CEIL



Rounds the number up.

Syntax

CEIL( <x> )

Aliases

Examples

SELECT CEILING(-1.23), CEIL(-1.23); ┌────────────────────────────────────┐ │ ceiling((- 1.23)) │ ceil((- 1.23)) │ ├───────────────────┼────────────────┤ │ -1-1 │ └────────────────────────────────────┘

Was this page helpful?