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.
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.
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