Applies to: Databricks SQL Databricks Runtime
Returns the rounded
HALF_EVEN rounding mode.
expr: A numeric expression.
targetScale: An INTEGER expression greater or equal to 0. If
targetScaleis omitted the default is 0.
expr is DECIMAL the result is DECIMAL with a scale that is the smaller of
expr scale and
HALF_EVEN rounding, also known as Gaussian or banker’s rounding, the digit 5 is rounded towards an even digit.