round_even()

Rounds x to s decimal places, rounding halfway cases to the nearest even digit

Reference: DuckDB 2.0.0

Arguments & returns

8 overloads

round_even(x, precision)

Scalar
Overload link xprecision Returns
#01 BIGINTINTEGER BIGINT
#02 DECIMALINTEGER DECIMAL
#03 DOUBLEINTEGER DOUBLE
#04 FLOATINTEGER FLOAT
#05 HUGEINTINTEGER HUGEINT
#06 INTEGERINTEGER INTEGER
#07 SMALLINTINTEGER SMALLINT
#08 TINYINTINTEGER TINYINT

Example

round_even example
SQL
Haybarn WASM 2.0.0-rc12 ยท In your browser

Engine example ยท Run to view results.

In other engines

BigQueryround()

SELECT ROUND(NUMERIC '2.25', 1, 'ROUND_HALF_EVEN') AS value
In DuckDB
SELECT ROUND_EVEN(CAST('2.25' AS DECIMAL), 1) AS value

SQLGlot example โ†—

Snowflakeround()

SELECT ROUND(2.25, 1, 'HALF_TO_EVEN') AS value
In DuckDB
SELECT ROUND_EVEN(2.25, 1) AS value

SQLGlot example โ†—