Numbers & math
Scalar
subtract()
Alias of -
Arguments & returns
37 overloadssubtract(col0)
Scalar
| Overload link | col0 |
Returns |
|---|---|---|
| #01 | BIGINT |
BIGINT |
| #02 | BIGNUM |
BIGNUM |
| #03 | DECIMAL |
DECIMAL |
| #04 | DOUBLE |
DOUBLE |
| #05 | FLOAT |
FLOAT |
| #06 | HUGEINT |
HUGEINT |
| #07 | INTEGER |
INTEGER |
| #08 | INTERVAL |
INTERVAL |
| #09 | SMALLINT |
SMALLINT |
| #10 | TINYINT |
TINYINT |
| #11 | UBIGINT |
UBIGINT |
| #12 | UHUGEINT |
UHUGEINT |
| #13 | UINTEGER |
UINTEGER |
| #14 | USMALLINT |
USMALLINT |
| #15 | UTINYINT |
UTINYINT |
subtract(col0, col1)
Scalar
| Overload link | col0 | col1 |
Returns |
|---|---|---|---|
| #16 | BIGINT | BIGINT |
BIGINT |
| #17 | BIGNUM | BIGNUM |
BIGNUM |
| #18 | DATE | DATE |
BIGINT |
| #19 | DATE | INTEGER |
DATE |
| #20 | DATE | INTERVAL |
TIMESTAMP |
| #21 | DECIMAL | DECIMAL |
DECIMAL |
| #22 | DOUBLE | DOUBLE |
DOUBLE |
| #23 | FLOAT | FLOAT |
FLOAT |
| #24 | HUGEINT | HUGEINT |
HUGEINT |
| #25 | INTEGER | INTEGER |
INTEGER |
| #26 | INTERVAL | INTERVAL |
INTERVAL |
| #27 | SMALLINT | SMALLINT |
SMALLINT |
| #28 | TIME WITH TIME ZONE | INTERVAL |
TIME WITH TIME ZONE |
| #29 | TIME | INTERVAL |
TIME |
| #30 | TIMESTAMP | INTERVAL |
TIMESTAMP |
| #31 | TIMESTAMP | TIMESTAMP |
INTERVAL |
| #32 | TINYINT | TINYINT |
TINYINT |
| #33 | UBIGINT | UBIGINT |
UBIGINT |
| #34 | UHUGEINT | UHUGEINT |
UHUGEINT |
| #35 | UINTEGER | UINTEGER |
UINTEGER |
| #36 | USMALLINT | USMALLINT |
USMALLINT |
| #37 | UTINYINT | UTINYINT |
UTINYINT |