Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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

Community Additions

ADD
Show:
© 2015 Microsoft