Functions/Numbers & math/trunc

Numbers & math Scalar

trunc()

Truncates the number

Arguments & returns

13 overloads

`trunc(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`
#09	`UBIGINT`	`UBIGINT`
#10	`UHUGEINT`	`UHUGEINT`
#11	`UINTEGER`	`UINTEGER`
#12	`USMALLINT`	`USMALLINT`
#13	`UTINYINT`	`UTINYINT`

Example

SELECT trunc(17.4);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.

In other engines

PostgreSQL`trunc()`

Oracle`trunc()`

Snowflake`trunc()`

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3