PI (Transact-SQL)
**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![yes](media/yes.png)Azure SQL Data Warehouse ![yes](media/yes.png)Parallel Data Warehouse
Returns the constant value of PI.
Transact-SQL Syntax Conventions
Syntax
PI ( )
Return Types
float
Examples
The following example returns the value of PI
.
SELECT PI();
GO
Here is the result set.
------------------------
3.14159265358979
(1 row(s) affected)
See Also
Mathematical Functions (Transact-SQL)