round

Returns "numeric_expression" rounded to the nearest value "integer_expression" places 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 ( 125 , -1 )

Result

Returns 130