MULTIPLY()
All functions > DATE AND TIME > MULTIPLY()
Scales an interval by an integer factor.
Signatures
Interval scaling
Returns: The scaled interval
MULTIPLY(interval: INTERVAL, factor: BIGINT) → INTERVALsql
| Parameter | Type | Required | Description |
|---|---|---|---|
interval | INTERVAL | Yes | Interval to scale |
factor | BIGINT | Yes | Integer scale factor (TINYINT, SMALLINT, INT, or BIGINT) |
Signature notes:
- Either operand order is accepted:
interval * norn * interval - Returns NULL if either operand is NULL
Related operators
Examples
MULTIPLY(...)
FeatureQL
SELECT
f1 := MULTIPLY(3, 4) -- Function call
;Result
| f1 BIGINT |
|---|
| 12 |
.MULTIPLY(...) — chained
FeatureQL
SELECT
f1 := (3).MULTIPLY(4), -- Integer literal: parenthesize for `.MULTIPLY` on BIGINT
f2 := 1.5.MULTIPLY(3) -- Decimal base: chain without extra parentheses
;Result
| f1 BIGINT | f2 VARCHAR |
|---|---|
| 12 | 4.5 |
Interval scaling
FeatureQL
SELECT
f1 := INTERVAL_PARSE('1 day') * 3, -- Scale a day interval
f2 := 5 * INTERVAL_PARSE('2 hours'), -- Integer on the left side
f3 := INTERVAL_PARSE('15 minutes') * 4, -- Compose sub-hour intervals
f4 := INTERVAL_PARSE('1 hour') * 0 -- Zero factor yields zero interval
;Result
| f1 VARCHAR | f2 VARCHAR | f3 VARCHAR | f4 VARCHAR |
|---|---|---|---|
| 3 days 00:00:00 | 0 days 10:00:00 | 0 days 01:00:00 | 0 days 00:00:00 |
Edge cases
FeatureQL
SELECT
f1 := MULTIPLY(-5, 2), -- Negative factor
f2 := MULTIPLY(0, 100), -- Multiplication by zero
f3 := MULTIPLY(1.5, 3.0), -- DECIMAL × DECIMAL
f4 := MULTIPLY(1.5E0, 3.0E0) -- DOUBLE × DOUBLE
;Result
| f1 BIGINT | f2 BIGINT | f3 VARCHAR | f4 VARCHAR |
|---|---|---|---|
| -10 | 0 | 4.5 | 4.5 |