MULTIPLY
All functions > MATH > MULTIPLY
Multiplies two numbers and returns their product.
Syntax
MULTIPLY(number1: T, number2: T) → Tsql
Type Parameters:
T: Numeric type: BIGINT, FLOAT, DOUBLE, or DECIMAL (both args same type)
Arguments
| Parameter | Type | Required | Description |
|---|---|---|---|
number1 | T | Yes | First number to multiply |
number2 | T | Yes | Second number to multiply |
Returns
Same as input type - BIGINT, FLOAT, DOUBLE, or DECIMAL
Notes
- Both arguments must be of the same numeric type
- Returns NULL if either operand is NULL
- Multiplication is commutative:
a * b = b * a - Operator form:
number1 * number2 - Overflow behavior depends on the underlying SQL engine
- Zero multiplied by any number results in zero