{ CEIL | CEILING } ( <numeric value expression> )

§

The CEILING function returns the smallest whole number (scale 0) that is greater than or equal to the argument.

§

The data type of the result is the same type as the argument.

§

If the argument is null, then the result is null.

Expression

Result

CEILING( 5 )

5

CEILING( 5.25 )

6

CEILING( -5.25 )

-5

SQL:2003 standard

-

Feature T621 "Enhanced numeric functions"