1. SQL Reference Guide
  2. Built-in Functions
  3. Functions of Mathematical Operations
  4. pi function

pi function

The pi function returns the value of pi, that is, 3.141592653589793.

Syntax:

double pi()
Semantics:
  • The pi function does not expect any input arguments.
  • return type: double.
Example:
SELECT pi() AS PI FROM Archery
Output:
 +-----------+-------------------+
 | PI        | 3.141592653589793 |
 +-----------+-------------------+