round

Returns "numeric_expression" rounded to "integer_expression" places to the right of the decimal point. If "integer_expression" is negative, "numeric_expression" is rounded to the nearest absolute value "integer_expression" places to the left of the decimal point. Rounding takes place before data formatting is applied.

Syntax

round ( numeric_expression, integer_expression )

Example

round ( 3.14159265, 3 )

Result

Returns 3.142.