roundbankers()

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

Reference: DuckDB 2.0.0

Alias of round_even()

Arguments & returns

8 overloads

roundbankers(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

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

Engine example ยท Run to view results.