Numbers & math
Scalar
pi()
Returns the value of pi
Arguments & returns
pi()
Scalar
| Overload link | Returns |
|---|---|
| #01 | DOUBLE |
Example
Haybarn WASM 1.5.5-rc3 · In your browser
Engine example · Run to view results.
In other engines
Used in larger rewrites 1
These examples use pi as one part of a larger SQL translation.
Snowflake
NORMAL(10.5, 2.5, RANDOM())
In Haybarn10.5 + (2.5 * SQRT(-2 * LN(GREATEST(RANDOM(), 1e-10))) * COS(2 * PI() * RANDOM()))