round_even()

Arguments & returns

Macro

Overload link	`x`	`n`	Returns
#01	`unknown`	`unknown`	`unknown`

CASE
  WHEN ((((abs(x) * power(10, (n + 1))) % 10) = 5)) THEN ((round((x / 2), n) * 2))
  ELSE round(x, n)
END

SELECT ROUND(NUMERIC '2.25', 1, 'ROUND_HALF_EVEN') AS value

In DuckDB

SELECT ROUND_EVEN(CAST('2.25' AS DECIMAL), 1) AS value

SELECT ROUND(2.25, 1, 'HALF_TO_EVEN') AS value

In DuckDB

SELECT ROUND_EVEN(2.25, 1) AS value