MySQL RADIANS() Function

The MySQL RADIANS() function returns an angle measured in degrees to an approx. equivalent angle measured in radians.

Syntax

RADIANS(x)

Parameters

`x`	`Required.` Specify an angle in degrees.

Return Value

Returns the angle measured in radians.

Example 1:

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

mysql> SELECT RADIANS(0);
Result: 0

mysql> SELECT RADIANS(30);
Result: 0.5235987755982988

mysql> SELECT RADIANS(60);
Result: 1.0471975511965976

mysql> SELECT RADIANS(90);
Result: 1.5707963267948966

mysql> SELECT RADIANS(180);
Result: 3.141592653589793

mysql> SELECT RADIANS(-90);
Result: -1.5707963267948966

mysql> SELECT RADIANS(-180);
Result: -3.141592653589793

Example 2:

Consider a database table called Sample with the following records:

Data	x
Data 1	0
Data 2	30
Data 3	60
Data 4	90
Data 5	180

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

SELECT *, RADIANS(x) AS RADIANS_Value FROM Sample;

This will produce the result as shown below:

Data	x	RADIANS_Value
Data 1	0	0
Data 2	30	0.5235987755982988
Data 3	60	1.0471975511965976
Data 4	90	1.5707963267948966
Data 5	180	3.141592653589793

❮ MySQL Functions