MULTIPLY

All functions > MATH > MULTIPLY

Multiplies two numbers and returns their product.

Syntax

MULTIPLY(number1: T, number2: T) → T
sql

Type Parameters:

  • T: Numeric type: BIGINT, FLOAT, DOUBLE, or DECIMAL (both args same type)

Arguments

ParameterTypeRequiredDescription
number1TYesFirst number to multiply
number2TYesSecond 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

See also

Examples

Suggest changes to this page
Last update at: 2025/10/13 10:23:46