MariaDB PI() Function

The MariaDB PI() function returns the value of 𝜋 (pi) displayed with 6 decimal places.

Note: This function displays the value of 𝜋 with only 6 decimal places. However, internally it uses the double-precision value when used in calculations with other double-precision values.

Syntax

PI()

Parameters

No parameter is required.

Return Value

Returns the value of 𝜋.

Example 1:

The example below shows the usage of PI() function.

SELECT PI();
Result: 3.141593

SELECT PI() * 1;
Result: 3.141593

SELECT PI() * 1.00;
Result: 3.141593

SELECT PI() * 1.00000000000000;
Result: 3.14159265358979

Example 2:

Consider a database table called Sample with the following records:

Data	Radius
Data 1	1
Data 2	2
Data 3	3
Data 4	4
Data 5	5

The statement given below can be used to calculate the area of the circle where radius is specified by values of column Radius.

SELECT *, (PI() * Radius * Radius) AS Area FROM Sample;

This will produce the result as shown below:

Data	Radius	Area
Data 1	1	3.141593
Data 2	2	12.566371
Data 3	3	28.274334
Data 4	4	50.265482
Data 5	5	78.539816

❮ MariaDB Functions