Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
SSIS Integration Runtime in Azure Data Factory
Returns the largest integer that is less than or equal to a numeric expression.
Syntax
FLOOR(numeric_expression)
Arguments
numeric_expression
Is a valid numeric expression.
Result Types
The numeric data type of the argument expression. The result is the integer portion of the calculated value in the same data type as numeric_expression.
Remarks
FLOOR returns a null result if the argument is null.
Expression Examples
These examples apply the FLOOR function to positive, negative, and zero values.
FLOOR(123.45)
Returns 123.00
FLOOR(-123.45)
Returns -124.00
FLOOR(0.00)
Returns 0.00