PI (Transact-SQL)

PI (Transact-SQL)

 

THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel Data Warehouse

Returns the constant value of PI.

Topic link icon Transact-SQL Syntax Conventions


PI ( )
-- Azure SQL Data Warehouse and Parallel Data Warehouse
PI ()

The following example returns the value of PI.

SELECT PI();
GO

Here is the result set.

------------------------
3.14159265358979

(1 row(s) affected)

The following example returns the value of PI.

SELECT PI();
GO

Here is the result set.

------------------------
3.14159265358979

(1 row(s) affected)

Community Additions

ADD
Show:
© 2016 Microsoft