CEILING

    Syntax

    CEILING( number )
    

    Description

    Rounds the value up to the nearest integer.

    Argument types:

    • numberFractional number | Integer

    Return type: Fractional number

    Example

    [value] CEILING([value])
    1.00 1.00
    0.10 1.00
    -2.00 -2.00
    50.50 51.00
    0.00 0.00
    -3.50 -3.00

    Data source support

    ClickHouse 19.13, Microsoft SQL Server 2017 (14.0), MySQL 5.6, PostgreSQL 9.3.