SQL Tutorial SQL Advanced SQL Database SQL References

MySQL DEGREES() Function



The MySQL 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.

Example 1:

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

mysql> SELECT DEGREES(0);
Result: 0

mysql> SELECT DEGREES(1);
Result: 57.29577951308232

mysql> SELECT DEGREES(2);
Result: 114.59155902616465

mysql> SELECT DEGREES(3);
Result: 171.88733853924697

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

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

mysql> SELECT DEGREES(PI());
Result: 180

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 10
Data 21
Data 32
Data 43
Data 54

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 100
Data 2157.29577951308232
Data 32114.59155902616465
Data 43171.88733853924697
Data 54229.1831180523293

❮ MySQL Functions