floor

Returns the largest integer that is less than or equal to the specified value.

Syntax

floor(numeric)

numeric – is any exact numeric (numeric, dec, decimal, tinyint, smallint, int, or bigint), approximate numeric (float, real, or double precision), or money column, variable, constant expression, or a combination of these.

Example 1 – Returns the largest integer that is less than or equal to 123:
```
select floor(123)
```
```
----------- 
        123
```
Example 2 – Returns the largest integer that is less than or equal to the 123.45:
```
select floor(123.45)
```
```
------- 
    123 
```
Example 3 – Returns the largest integer that is less than or equal to 1.2345E2:
```
select floor(1.2345E2)
```
```
-------------------- 
         123.000000
```
Example 4 – Returns the largest integer that is less than or equal to -123.45:
```
select floor(-123.45)
```
```
------- 
   -124 
```
Example 5 – Returns the largest integer that is less than or equal to -1.2345E2:
```
select floor(-1.2345E2)
```
```
-------------------- 
        -124.000000
```
Example 6 – Returns the largest integer that is less than or equal to $123.45:
```
select floor($123.45)
```
```
------------------------ 
                 123.00 
```

For numeric and decimal expressions, the results have a precision equal to that of the expression and a scale of 0.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute floor.