Export (0) Print
Expand All

CEILING (SSIS Expression)

 

Returns the smallest integer that is greater than or equal to a numeric expression.


CEILING(numeric_expression)

numeric_expression

Is a valid numeric expression.

The data type of the numeric expression submitted to the function.

CEILING returns a null result if the argument is null.

These examples apply the CEILING function to positive, negative, and zero values.

CEILING(123.74)

Returns 124.00

CEILING(-124.27)

Returns -124.00

CEILING(0.00)

Returns 0.00

Show:
© 2015 Microsoft