SQL Server Tutorial SQL Server Advanced SQL Server Database SQL Server References

SQL Server PI() Function



The SQL Server (Transact-SQL) PI() function returns the value of 𝜋 (pi).

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.141592653589793

Example 2:

Consider a database table called Sample with the following records:

DataRadius
Data 11
Data 22
Data 33
Data 44
Data 55

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:

DataRadiusArea
Data 113.141592653589793
Data 2212.566370614359172
Data 3328.274333882308138
Data 4450.26548245743669
Data 5578.53981633974483

❮ SQL Server Functions