docs.intersystems.com
Home / InterSystems SQL Reference / SQL Functions / PI

InterSystems SQL Reference
PI
Previous section           Next section
InterSystems: The power behind what matters   
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 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


Previous section           Next section
Send us comments on this page
View this book as PDF   |  Download all PDFs
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA
Content Date/Time: 2019-07-23 06:35:03