Numbers & math Scalar

trunc()

Truncates the number

Arguments & returns

26 overloads

Scalar

Scalar

Overload link	`x`	`col1`	Returns
#14	`BIGINT`	`INTEGER`	`BIGINT`
#15	`DECIMAL`	`INTEGER`	`DECIMAL`
#16	`DOUBLE`	`INTEGER`	`DOUBLE`
#17	`FLOAT`	`INTEGER`	`FLOAT`
#18	`HUGEINT`	`INTEGER`	`HUGEINT`
#19	`INTEGER`	`INTEGER`	`INTEGER`
#20	`SMALLINT`	`INTEGER`	`SMALLINT`
#21	`TINYINT`	`INTEGER`	`TINYINT`
#22	`UBIGINT`	`INTEGER`	`UBIGINT`
#23	`UHUGEINT`	`INTEGER`	`UHUGEINT`
#24	`UINTEGER`	`INTEGER`	`UINTEGER`
#25	`USMALLINT`	`INTEGER`	`USMALLINT`
#26	`UTINYINT`	`INTEGER`	`UTINYINT`

SELECT trunc(17.4);

Haybarn WASM 1.5.5-rc3 · In your browser

Engine example · Run to view results.