Math

DIV

BigQuery

Melakukan pembagian integer (floor division), membuang sisa.

Tipe hasil: INT64 or NUMERICDiperbarui: 7 Jan 2026

Syntax

SQL

DIV(dividend, divisor)

dividendINT64/NUMERIC/BIGNUMERICwajib

Angka yang dibagi

divisorINT64/NUMERIC/BIGNUMERICwajib

Angka pembagi

SQL

1 SELECT
2   DIV(10, 3) as int_div,
3   10 / 3 as float_div,
4   MOD(10, 3) as remainder;

Perbandingan DIV dengan pembagian biasa.

Hasil

int_div	float_div	remainder
3	3.333...	1

SQL

1 SELECT
2   total_minutes,
3   DIV(total_minutes, 60) as hours,
4   MOD(total_minutes, 60) as remaining_minutes
5 FROM `project.dataset.duration`;

Konversi menit ke jam dan menit.

1	SELECT
2	total_minutes,
3	DIV(total_minutes, 60) as hours,
4	MOD(total_minutes, 60) as remaining_minutes
5	FROM `project.dataset.duration`;