CEILING (Transact-SQL)

CEILING (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

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

Topic link icon Transact-SQL Syntax Conventions


CEILING ( numeric_expression )
-- Azure SQL Data Warehouse and Parallel Data Warehouse
CEILING (numeric_expression )

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

Returns the same type as numeric_expression.

The following example shows positive numeric, negative, and zero values with the CEILING function.

SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0);
GO

Here is the result set.

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

(1 row(s) affected)

The following example shows use of positive numeric, negative, and zero values with the CEILING function.

SELECT CEILING(123.45), CEILING(-123.45), CEILING(0.0);

Here is the result set.

------- --------- --------

124.00  -123.00   0.00

Community Additions

ADD
Show:
© 2016 Microsoft