Note
Access to this page requires authorization. You can try signing in or .
Access to this page requires authorization. You can try .
DEGREES (Transact-SQL)
Applies to: 👁 Image
SQL Server 👁 Image
Azure SQL Database 👁 Image
Azure SQL Managed Instance 👁 Image
Azure Synapse Analytics 👁 Image
Analytics Platform System (PDW) 👁 Image
SQL analytics endpoint in Microsoft Fabric 👁 Image
Warehouse in Microsoft Fabric 👁 Image
SQL database in Microsoft Fabric
This function returns the corresponding angle, in degrees, for an angle specified in radians.
👁 Image
Transact-SQL syntax conventions
Syntax
DEGREES ( numeric_expression )
Arguments
numeric_expression
An expression of the exact numeric or approximate numeric data type category.
Return Types
The return type depends on the input type of numeric_expression:
| Input type | Return type |
|---|---|
| float, real | float |
| decimal(p, s) | decimal(38, s) |
| int, smallint, tinyint | int |
| bigint | bigint |
| money, smallmoney | money |
| bit | float |
If the result does not fit in the return type, an arithmetic overflow error occurs.
Examples
This example returns the number of degrees in an angle of PI/2 radians.
SELECT 'The number of degrees in PI/2 radians is: ' +
CONVERT(VARCHAR, DEGREES((PI()/2)));
GO
Here's the result set.
The number of degrees in PI/2 radians is 90
(1 row(s) affected)
See Also
Feedback
Was this page helpful?