TechNet
Export (0) Print
Expand All

FLOOR (Transact-SQL)

 

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

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

Topic link icon Transact-SQL Syntax Conventions

-- Syntax for SQL Server, Azure SQL Data Warehouse, Parallel Data Warehouse  
  
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     

The following example shows positive numeric, negative numeric, and 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

Mathematical Functions (Transact-SQL)

Community Additions

ADD
Show:
© 2016 Microsoft