Math

SAFE_MULTIPLY

BigQuery

Melakukan perkalian aman yang mengembalikan NULL jika terjadi overflow.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL

SAFE_MULTIPLY(x, y)

xINT64/NUMERIC/BIGNUMERICwajib

Operand pertama

yINT64/NUMERIC/BIGNUMERICwajib

Operand kedua

SQL

1 SELECT
2   SAFE_MULTIPLY(1000000000000, 1000000000000) as might_overflow,
3   SAFE_MULTIPLY(100, 200) as normal_multiply;

Perkalian yang aman dari overflow.

Hasil

might_overflow	normal_multiply
NULL	20000

1	SELECT
2	SAFE_MULTIPLY(1000000000000, 1000000000000) as might_overflow,
3	SAFE_MULTIPLY(100, 200) as normal_multiply;