Math

TRUNC

BigQuery

Memotong angka ke precision yang ditentukan tanpa pembulatan (truncation toward zero).

Tipe hasil: Same as input typeDiperbarui: 7 Jan 2026

Syntax

SQL

TRUNC(expression [, precision])

expressionFLOAT64/NUMERIC/BIGNUMERICwajib

Nilai numerik untuk dipotong

precisionINT64opsional

Jumlah digit desimal (default: 0)

Default: 0

SQL

1 SELECT
2   value,
3   TRUNC(value) as truncated,
4   ROUND(value) as rounded,
5   FLOOR(value) as floored
6 FROM UNNEST([2.7, -2.7]) as value;

Perbandingan TRUNC dengan ROUND dan FLOOR.

Hasil

value	truncated	rounded	floored
2.7	2	3	2
-2.7	-2	-3	-3

SQL

1 SELECT
2   price,
3   TRUNC(price, 2) as price_two_decimals
4 FROM `project.dataset.products`;

Memotong harga ke 2 desimal tanpa rounding.

1	SELECT
2	price,
3	TRUNC(price, 2) as price_two_decimals
4	FROM `project.dataset.products`;