SQL Server FLOOR() Function

Return the largest integer value that is equal to or less than 25.75:

SELECT FLOOR(25.75) AS FloorValue;

Definition and Usage

The FLOOR() function returns the largest integer value that is smaller than or equal to a number.

Tip: Also look at the CEILING() and ROUND() functions.

FLOOR( number)

Parameter	Description
number	Required. A numeric value

Works in:	SQL Server (starting with 2008), Azure SQL Data Warehouse, Parallel Data Warehouse

Return the largest integer value that is equal to or less than 25:

SELECT FLOOR(25) AS FloorValue;

Return the largest integer value that is equal to or less than -13.5:

SELECT FLOOR(-13.5) AS FloorValue;