Skip to main content
Returns π as a DOUBLE PRECISION value.

Syntax

PI() 

Return Type

PI returns a value of type DOUBLE PRECISION.

Example

The following example gets the value of pi:
SELECT pi() as result;
result double
3.141592653589793

Rows: 1Execution time: 5.67ms