Skip to contents

DuckDB function trunc

Source: R/duckdb-funs.R
trunc.Rd

Truncates the number.

Arguments

x

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | DECIMAL | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT

col1

INTEGER

Value

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | DECIMAL | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT

Overloads

  • trunc(x = TINYINT)

  • trunc(x = TINYINT, col1 = INTEGER)

  • trunc(x = SMALLINT)

  • trunc(x = SMALLINT, col1 = INTEGER)

  • trunc(x = INTEGER)

  • trunc(x = INTEGER, col1 = INTEGER)

  • trunc(x = BIGINT)

  • trunc(x = BIGINT, col1 = INTEGER)

  • trunc(x = HUGEINT)

  • trunc(x = HUGEINT, col1 = INTEGER)

  • trunc(x = FLOAT)

  • trunc(x = FLOAT, col1 = INTEGER)

  • trunc(x = DOUBLE)

  • trunc(x = DOUBLE, col1 = INTEGER)

  • trunc(x = DECIMAL)

  • trunc(x = DECIMAL, col1 = INTEGER)

  • trunc(x = UTINYINT)

  • trunc(x = UTINYINT, col1 = INTEGER)

  • trunc(x = USMALLINT)

  • trunc(x = USMALLINT, col1 = INTEGER)

  • trunc(x = UINTEGER)

  • trunc(x = UINTEGER, col1 = INTEGER)

  • trunc(x = UBIGINT)

  • trunc(x = UBIGINT, col1 = INTEGER)

  • trunc(x = UHUGEINT)

  • trunc(x = UHUGEINT, col1 = INTEGER)

SQL examples

trunc(17.4)