Math

SAFE_NEGATE

BigQueryBigQuery

Mengembalikan negasi (nilai negatif) secara aman, NULL jika overflow.

Tipe hasil: Same as inputDiperbarui: 7 Jan 2026

Syntax

SQL
SAFE_NEGATE(expression)

Parameter

expressionINT64/NUMERIC/BIGNUMERICwajib

Nilai numerik

Contoh Penggunaan

Safe Negation

SQL
1SELECT
2  SAFE_NEGATE(100) as negated,
3  SAFE_NEGATE(-50) as double_neg,
4  SAFE_NEGATE(-9223372036854775808) as min_int64;

Negasi aman dengan handling edge case.

Hasil
negateddouble_negmin_int64
-10050NULL
Kembali ke BigQuery Functions