PI (Transact-SQL)
Applies to:
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
SQL analytics endpoint in Microsoft Fabric
Warehouse in Microsoft Fabric
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's the result set.
------------------------
3.14159265358979
(1 row(s) affected)