PI()

PI() — Returns the value of the mathematical constant pi (π) as a FLOAT value.

Synopsis

PI()

PI

Description

The PI() function returns the value of the mathematical constant pi (π) as a double floating point (FLOAT) value. Since there are no arguments to the function, the parentheses following the function name are optional.

Example

The following example uses the PI() function to return the surface area of a sphere.

SELECT radius, 4*PI*POWER(radius, 2) FROM Sphere ORDER BY radius;