Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

PI

Returns the value of pi to 7 decimal places. The full double precision value is used internally if PI() is used as part of an expression.

Syntax

PI()

Return Type

Double.

Examples

SELECT PI();
+----------+
| PI()     |
+----------+
| 3.141593 |
+----------+