MySQL: PI Function
This MySQL tutorial explains how to use the MySQL PI function with syntax and examples.
Description
The MySQL PI function returns the value of π (pi) displayed with 6 decimal places.
Syntax
The syntax for the PI function in MySQL is:
PI( )
Parameters or Arguments
There are no parameters or arguments for the PI function.
Note
Applies To
The PI function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL PI function examples and explore how to use the PI function in MySQL.
For example:
mysql> SELECT PI(); Result: 3.141593 mysql> SELECT PI()*1; Result: 3.141593 mysql> SELECT PI()*1.000000000000000; Result: 3.141592653589793
Advertisements