This example shows positive numeric, negative numeric, and zero value inputs for the CEILING function.
The feedback system for this content will be changing soon. Old comments will not be carried over. If content within a comment thread is important to you, please save a copy. For more information on the upcoming change,we invite you to read our blog post.
Return values have the same type asnumeric_expression.
This function returns the smallest integer greater than, or equal to, the specified numeric expression.
System Functions Transact-SQL
Anexpressionof the exact numeric or approximate numeric data type category. For this function, thebitdata type is invalid.