Chapter 2: Transact-SQL Functions

floor

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

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.

select floor(123)

----------- 
        123

select floor(123.45)

------- 
    123

select floor(1.2345E2)

-------------------- 
         123.000000

select floor(-123.45)

------- 
   -124

select floor(-1.2345E2)

-------------------- 
        -124.000000

select floor($123.45)

------------------------ 
                 123.00

floor, a mathematical function, returns the largest integer that is less than or equal to the specified value. Results are of the same type as the numeric expression.

For numeric and decimal expressions, the results have a precision equal to that of the expression and a scale of 0.
For general information about mathematical functions, see “Mathematical functions”.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute floor.