PI (Transact-SQL)
Applies to: SQL Server (all supported versions)
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Parallel Data Warehouse
Returns the constant value of PI.
Transact-SQL Syntax Conventions
Syntax
PI ( )
Note
To view Transact-SQL syntax for SQL Server 2014 and earlier, see Previous versions documentation.
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)