SQLite PI() Function
The SQLite 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.14159265358979 SELECT PI() / 2; Result: 1.5707963267949
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.14159265358979 |
| Data 2 | 2 | 12.5663706143592 |
| Data 3 | 3 | 28.2743338823081 |
| Data 4 | 4 | 50.2654824574367 |
| Data 5 | 5 | 78.5398163397448 |
❮ SQLite Functions
