w3resource
MYSQL Tutorial

MySQL PI() function

PI() function

MySQL PI() returns the value of π(pi).

Syntax:

PI();

Pictorial presentation of MySQL PI() function

pictorial presentation of MySQL PI() function

Example of MySQL PI() function

Code:

SELECT PI();

Explanation

The above MySQL statement returns the value of PI().

Sample Output:

mysql> SELECT PI();
+----------+
| PI()     |
+----------+
| 3.141593 | 
+----------+
1 row in set (0.00 sec)

All Mathematical Functions

MySQL Mathematical Functions, slide presentation

Previous: OCT()
Next: POW()