CEILING (SSIS Expression)
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Returns the smallest integer that is greater than or equal to a numeric expression.
Syntax
CEILING(numeric_expression)
Arguments
numeric_expression
Is a valid numeric expression.
Result Types
The data type of the numeric expression submitted to the function.
Remarks
CEILING returns a null result if the argument is null.
Expression Examples
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
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for