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

FLOOR (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

Returns the largest integer less than or equal to the specified numeric expression.

Applies to: SQL Server (SQL Server 2008 through current version) , Azure SQL Data Warehouse Public Preview.

Topic link icon Transact-SQL Syntax Conventions


FLOOR ( 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 numeric, and currency values with the FLOOR function.

SELECT FLOOR(123.45), FLOOR(-123.45), FLOOR($123.45);

The result is the integer part of the calculated value in the same data type as numeric_expression.

---------      ---------     -----------
123            -124          123.0000   

Community Additions

ADD
Show:
© 2015 Microsoft