SQL) ceiling Function

The ceiling function returns the smallest integer greater than or equal to the given numeric expression. The floor function returns the largest integer less than or equal to the given numeric expression.
For example, for the numeric expression 12.9273, ceiling returns 13 and floor returns 12. The data types returned by floor and ceiling are the same as those of the input numeric expression.

Returns the smallest integer greater than or equal to the specified value expression.

Transact-SQL syntax conventions

Syntax

Ceiling (numeric_expression)

Parameters

Numeric_expression

Is a type of exact or approximate numeric data (BitExcept for data types)Expression.

Return type

Returns andNumeric_expressionThe same type.

Example

The following example shows the positive, negative, and zero values of the ceiling function.

Select ceiling ($123.45), ceiling ($-123.45), ceiling ($0.0)
Go

The following is the result set:

-------------------------------------------
124.00-123.00 0.00

(1 row (s) affected)