ROUND

Returns a numeric expression rounded to the specified length or precision.

Note: This function is equivalent to ROUND in T-SQL.

Return Value

Numeric

Syntax

ROUND( numExpr, length )

where:

  • numExpr is the numeric expression containing the value you want to have rounded.
  • length indicates the number of places or the precision to which the number should be rounded.

When length is a positive number, numExpr is rounded to the number of decimal positions specified by length. When length is a negative number, numExpr is rounded on the left side of the decimal point, as specified by length.