floor-transact-sql.md

title	FLOOR (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/03/2017
ms.prod	sql
ms.prod_service	sql-data-warehouse, pdw, sql-database
ms.reviewer
ms.technology	t-sql
ms.topic	language-reference
f1_keywords	FLOOR_TSQL FLOOR
dev_langs	TSQL
helpviewer_keywords	integers [SQL Server] largest integers FLOOR function [Transact-SQL]
ms.assetid	4f26c784-9240-491f-b854-754be3fccae4
author	MikeRayMSFT
ms.author	mikeray
monikerRange	>=aps-pdw-2016||=azure-sqldw-latest||>=sql-server-2016||=sqlallproducts-allversions||>=sql-server-linux-2017||=azuresqldb-mi-current

FLOOR (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all-md]

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

Transact-SQL Syntax Conventions

Syntax

FLOOR ( numeric_expression )  

Arguments

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

Return Types

Returns the same type as numeric_expression.

Examples

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     

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

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

See Also

Mathematical Functions (Transact-SQL)