|
Compatibility
| ROUND(f,p) |
| Engine |
OK |
Alternative |
| ingres |
yes |
|
| mysql |
yes |
|
| oracle |
yes |
|
| postgres |
yes |
|
| sqlserver |
yes |
|
ROUNDROUND(f,p) returns f rounded to p
decimal places.
The number of decimal places may be negative, this will round
to the nearest 10 (when p is -1) or 100 (when p is -2)
or 1000 (when p is -3) etc..
ROUND(2.7,0) -> 3
ROUND(2.71,1) -> 2.7
In this example we calculate the population in millions to one demial place.
|
Results
|
See also: | |