Rounds a non-integer value upwards to the next greatest integer.

This function returns a BIGINT datatype.

CEILING( numeric_expression )
CEIL( numeric_expression )

Required. Any expression that returns a numeric-class datatype.

> select latitude, ceiling(latitude) ceil_lat from countries;

LATITUDE                          CEIL_LAT
--------------------------------  ----------------------
                       42.500000                      43
                       24.000000                      24
                       33.000000                      33
                       17.049999                      18
                       18.209999                      19
                       41.000000                      41
                       40.000000                      40

See also: