Math

PI

DuckDB

Mengembalikan nilai konstanta matematika π (pi) = 3.141592653589793. Berguna untuk perhitungan geometri.

Tipe hasil: DOUBLEDiperbarui: 6 Jan 2026

Syntax

SQL

PI()

Fungsi ini tidak memerlukan parameter.

SQL

1 SELECT
2   PI() as pi_value,
3   PI() * 2 as two_pi,
4   PI() / 2 as half_pi;

Nilai pi dan kelipatannya.

Hasil

pi_value	two_pi	half_pi
3.141592653589793	6.283185307179586	1.5707963267948966

SQL

1 SELECT
2   radius,
3   2 * PI() * radius as circumference,
4   PI() * POWER(radius, 2) as area
5 FROM (SELECT unnest([1, 5, 10]) as radius);

Menghitung keliling (2πr) dan luas (πr²) lingkaran.

Hasil

SQL

1 SELECT
2   degrees,
3   degrees * PI() / 180 as radians
4 FROM (SELECT unnest([0, 45, 90, 180, 360]) as degrees);

Mengkonversi sudut dari derajat ke radian.

Hasil

1	SELECT
2	degrees,
3	degrees * PI() / 180 as radians
4	FROM (SELECT unnest([0, 45, 90, 180, 360]) as degrees);