Caché SQL Reference
PI
[Back] [Next]
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

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 DECIMAL 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