SQL Tutorial SQL Advanced SQL Database SQL References

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

x Required. Specify an angle in radians.

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:

Datax
Data 10.0
Data 21.0
Data 32.0
Data 43.0
Data 54.0

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:

DataxDEGREES_Value
Data 10.00
Data 21.057.29577951308232
Data 32.0114.59155902616465
Data 43.0171.88733853924697
Data 54.0229.1831180523293

❮ SQL Server Functions