Skip to contents

DuckDB function subtract

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

DuckDB function subtract().

Arguments

col0

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | DECIMAL | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT | BIGNUM | DATE | TIMESTAMP | INTERVAL | TIME | TIME WITH TIME ZONE

col1

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | DECIMAL | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT | BIGNUM | DATE | TIMESTAMP | INTERVAL

Value

TINYINT | SMALLINT | INTEGER | BIGINT | HUGEINT | FLOAT | DOUBLE | DECIMAL | UTINYINT | USMALLINT | UINTEGER | UBIGINT | UHUGEINT | BIGNUM | DATE | INTERVAL | TIMESTAMP | TIME | TIME WITH TIME ZONE

Overloads

  • subtract(col0 = TINYINT)

  • subtract(col0 = TINYINT, col1 = TINYINT)

  • subtract(col0 = SMALLINT)

  • subtract(col0 = SMALLINT, col1 = SMALLINT)

  • subtract(col0 = INTEGER)

  • subtract(col0 = INTEGER, col1 = INTEGER)

  • subtract(col0 = BIGINT)

  • subtract(col0 = BIGINT, col1 = BIGINT)

  • subtract(col0 = HUGEINT)

  • subtract(col0 = HUGEINT, col1 = HUGEINT)

  • subtract(col0 = FLOAT)

  • subtract(col0 = FLOAT, col1 = FLOAT)

  • subtract(col0 = DOUBLE)

  • subtract(col0 = DOUBLE, col1 = DOUBLE)

  • subtract(col0 = DECIMAL)

  • subtract(col0 = DECIMAL, col1 = DECIMAL)

  • subtract(col0 = UTINYINT)

  • subtract(col0 = UTINYINT, col1 = UTINYINT)

  • subtract(col0 = USMALLINT)

  • subtract(col0 = USMALLINT, col1 = USMALLINT)

  • subtract(col0 = UINTEGER)

  • subtract(col0 = UINTEGER, col1 = UINTEGER)

  • subtract(col0 = UBIGINT)

  • subtract(col0 = UBIGINT, col1 = UBIGINT)

  • subtract(col0 = UHUGEINT)

  • subtract(col0 = UHUGEINT, col1 = UHUGEINT)

  • subtract(col0 = BIGNUM)

  • subtract(col0 = BIGNUM, col1 = BIGNUM)

  • subtract(col0 = DATE, col1 = DATE)

  • subtract(col0 = DATE, col1 = INTEGER)

  • subtract(col0 = TIMESTAMP, col1 = TIMESTAMP)

  • subtract(col0 = INTERVAL, col1 = INTERVAL)

  • subtract(col0 = DATE, col1 = INTERVAL)

  • subtract(col0 = TIME, col1 = INTERVAL)

  • subtract(col0 = TIMESTAMP, col1 = INTERVAL)

  • subtract(col0 = `TIME WITH TIME ZONE`, col1 = INTERVAL)

  • subtract(col0 = INTERVAL)