CEILING (TSQL Function)

Returns the smallest integer greater than, or equal to, the value of the argument.

Syntax

CEILING ( numeric_expression )

Arguments

numeric_expression

is a numeric expression of type int, bigint, money, numeric, float.

Return Types

Returns the same type as numeric_expression.

Examples

PRINT CEILING(123), CEILING(123.45e0), CEILING($123.45), CEILING(123.45), CEILING(-123.45), CEILING(0.0);

The result is:

        123|                 124|             124.0000|    124|   -123|   0|