* [multiplication]

All functions > MATH > *** [multiplication]**

Returns the product of two numbers, or scales an interval by an integer factor.

Syntax

left * right  ·  MULTIPLY(left, right)

left * right  ·  MULTIPLY(left, right)

Notes

• Both operands must be compatible numeric types, or one must be INTERVAL and the other an integer
• When scaling an interval, either order is accepted: interval * n or n * interval
• Returns NULL if either operand is NULL
• Multiplication is commutative
• Very large finite magnitudes can overflow when using floating-point types

Related Functions

• MULTIPLY()

Examples

* — numeric

SELECT
    f1 := 3 * 4, -- Basic multiplication
    f2 := -5 * 2 -- Negative left operand
;

* — interval scaling

SELECT
    f1 := INTERVAL_PARSE('1 day') * 3, -- Scale a day interval
    f2 := 5 * INTERVAL_PARSE('2 hours') -- Integer on the left side
;

* — floating-point

SELECT
    f1 := 1.5E0 * 3.0E0 -- DOUBLE operands
;