Functions/Numbers & math/round

Numbers & math Scalar

round()

Rounds x to s decimal places

Arguments & returns

16 overloads

`round(x)`

Scalar

Overload link	`x`	Returns
#01	`BIGINT`	`BIGINT`
#02	`DECIMAL`	`DECIMAL`
#03	`DOUBLE`	`DOUBLE`
#04	`FLOAT`	`FLOAT`
#05	`HUGEINT`	`HUGEINT`
#06	`INTEGER`	`INTEGER`
#07	`SMALLINT`	`SMALLINT`
#08	`TINYINT`	`TINYINT`

`round(x, precision)`

Scalar

Overload link	`x`	`precision`	Returns
#09	`BIGINT`	`INTEGER`	`BIGINT`
#10	`DECIMAL`	`INTEGER`	`DECIMAL`
#11	`DOUBLE`	`INTEGER`	`DOUBLE`
#12	`FLOAT`	`INTEGER`	`FLOAT`
#13	`HUGEINT`	`INTEGER`	`HUGEINT`
#14	`INTEGER`	`INTEGER`	`INTEGER`
#15	`SMALLINT`	`INTEGER`	`SMALLINT`
#16	`TINYINT`	`INTEGER`	`TINYINT`

Example

SELECT round(42.4332, 2);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

BigQuery`round()`

Snowflake`round()`

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3