SQL Server - FLOOR() Function

The SQL Server (Transact-SQL) FLOOR() function returns the next lowest integer value by rounding down the specified number, if necessary. In other words, it rounds the fraction DOWN of the given number.

Syntax

FLOOR(x)

Parameters

Return Value

Returns the next lowest integer value by rounding DOWN the specified number, if necessary.

Example 1:

The example below shows the usage of FLOOR() function.

SELECT FLOOR(23);
Result: 23

SELECT FLOOR(23.3);
Result: 23

SELECT FLOOR(23.8);
Result: 23

SELECT FLOOR(-23);
Result: -23

SELECT FLOOR(-23.3);
Result: -24

SELECT FLOOR(-23.8);
Result: -24

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to round the fraction DOWN for all records of column x.

SELECT *, FLOOR(x) AS FLOOR_Value FROM Sample;

This will produce the result as shown below: