FLOOR function
Synopsis
This function
returns the greatest whole number less than or equal to the
specified number. Essentially, this function rounds the specified
number downwards to the closest whole number.
Variations
FLOOR(
Number)
Returns the largest whole number
less than or equal to the specified number.
Details |
Examples |
Details and examples
Parameters
Number
Specifies the number to round downwards.
Supported types: Numeric.
Returns
Examples
1. |
The following example returns 4.
FLOOR(4.3)
|
2. |
The following example also returns 4.
FLOOR(4)
|