PI Function [Numeric]

Returns the numeric value PI.

Syntax

PI ( * )

Returns

DOUBLE

Example

The following statement returns the value 3.141592653....

SELECT PI( * ) FROM iq_dummy

Standards and Compatibility

  • SQL—Vendor extension to ISO/ANSI SQL grammar.

  • Sybase—The PI() function is supported in Adaptive Server Enterprise, but PI(*) is not.

Parent topic: Alphabetical List of Functions