SQL PI()

The SQL math function PI() is used to return the mathematical constant π (PI), which is approximately 3.14. PI is a fundamental constant in mathematics, particularly in geometry, where it’s used to calculate properties of circles and spheres.

Syntax

PI()

Parameters:

The PI() function does not take any parameters.

Return value:

Returns the mathematical constant π (PI).

Example 1

In this example, the PI value is returned using the PI() function:

SELECT PI() AS pi_value;

Copy to clipboard
Copy to clipboard

The AS keyword is used to name the resulting column pi_value in the output:

Example 2

In this example, the following data is given in the circles table:

The PI() function is used to perform the calculation of the area of each circle:

SELECT id, radio, PI() * POWER(radius, 2) AS circle_area
FROM circles;

Copy to clipboard
Copy to clipboard

In this SQL statement, the value of PI is multiplied by the result of squaring the radius (radius) using the POWER() function to calculate the circle_area.

The output will be:

Note: Values are rounded to 2 decimal places for readability.