SQL Server DEGREES() Function
Updated on
DEGREES() converts an angle measured in radians to degrees. SQL Server trigonometric functions use radians; to convert a degree-valued input to radians, use RADIANS(). See Microsoft’s DEGREES() reference.
Syntax
DEGREES(numeric_expression)
Return type
The return type depends on the input type:
| Input type | Return type |
|---|---|
float, real |
float |
decimal(p, s) |
decimal(38, s) |
int, smallint, tinyint |
int |
bigint |
bigint |
money, smallmoney |
money |
bit |
float |
The function can overflow if the converted angle does not fit in the input-dependent return type.
Example: Convert radians to degrees
PI()/2 radians is 90 degrees:
SELECT DEGREES(PI() / 2) AS degrees;
| degrees |
|---|
| 90.0 |
DEGREES() converts from radians to degrees. If an angle is given in degrees and must be passed to a trigonometric function, convert it with RADIANS().