Skip to main content
Previous section   Next section

PI

A scalar numeric function that returns the constant value of pi.

Synopsis

{fn PI()}
{fn PI}

Description

PI takes no arguments. It returns the mathematical constant pi as data type NUMERIC with a precision of 19 and a scale of 18.

PI can only be invoked using ODBC scalar function (curly brace) syntax. Note that the argument parentheses are optional.

Examples

The following examples both return the value of pi:

SELECT {fn PI()} AS ExactPi
SELECT {fn PI} AS ExactPi

returns 3.141592653589793238.

See Also

  • SQL functions: ROUND

  • ObjectScript special variable: $ZPI

Previous section   Next section