SQL Server - DEGREES() Function

The SQL Server (Transact-SQL) DEGREES() function returns an angle measured in radians to an approx. equivalent angle measured in degrees.

Syntax

DEGREES(x)

Parameters

Return Value

Returns the angle measured in degrees (data type of returned value matches with x).

Example 1:

The example below shows the usage of DEGREES() function.

SELECT DEGREES(0);
Result: 0

SELECT DEGREES(1.0);
Result: 57.29577951308232

SELECT DEGREES(2.0);
Result: 114.59155902616465

SELECT DEGREES(3.0);
Result: 171.88733853924697

SELECT DEGREES(PI()/3);
Result: 59.99999999999999

SELECT DEGREES(PI()/2);
Result: 90

SELECT DEGREES(PI());
Result: 180

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to convert the records of column x (containing values expressed in radians) into degrees.

SELECT *, DEGREES(x) AS DEGREES_Value FROM Sample;

This will produce the result as shown below: