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