|
Compatibility
| FLOOR(f) |
| Engine |
OK |
Alternative |
| ingres |
yes |
|
| mysql |
yes |
|
| oracle |
yes |
|
| postgres |
yes |
|
| sqlserver |
yes |
|
FLOORFLOOR(f) returns the integer value of f
FLOOR(f) give the integer that is equal to, or just less
than f. FLOOR always rounds down.
FLOOR(2.7) -> 2
FLOOR(-2.7) -> -3
In this example we calculate the population in millions.
|
Results
|
See also: | |