version 11
ROUND (arithmetic_expression[, arithmetic_expression])
Description
The ROUND function rounds the first arithmetic_expression passed to "x" decimal places (where "x" is the second optional arithmetic_expression passed). If the second arithmetic_expression is not passed, the arithmetic_expression is rounded off to the nearest whole number.
Example
This example rounds the given number off to two decimal places:
ROUND (1234.1966, 2) `returns 1234.2000
See Also