MySQL RADIANS() Function – Convert From Degrees to Radians

In MySQL, the RADIANS() function converts a value from degrees to radians, and returns the result.

You provide the value in degrees as an argument when calling the function.

Syntax

The syntax goes like this:

RADIANS(X)

Where X is the value for which you’d like to have converted from degrees to radians.

Here’s a basic example.

SELECT RADIANS(75);

Result:

+--------------------+
| RADIANS(75)        |
+--------------------+
| 1.3089969389957472 |
+--------------------+

And here’s another example using a different value.

SELECT RADIANS(1);

Result:

+----------------------+
| RADIANS(1)           |
+----------------------+
| 0.017453292519943295 |
+----------------------+

Swapping the previous number to a negative value produces a negative result.

SELECT RADIANS(-1);

Result:

+-----------------------+
| RADIANS(-1)           |
+-----------------------+
| -0.017453292519943295 |
+-----------------------+

You can also pass in expressions like this:

SELECT RADIANS(20000 / 4);

Result:

+--------------------+
| RADIANS(20000 / 4) |
+--------------------+
|  87.26646259971648 |
+--------------------+

Obviously, passing in zero will result in zero.

SELECT RADIANS(0);

Result:

+------------+
| RADIANS(0) |
+------------+
|          0 |
+------------+

And passing in NULL returns NULL.

SELECT RADIANS(NULL);

Result:

+---------------+
| RADIANS(NULL) |
+---------------+
|          NULL |
+---------------+

And passing in a string results in zero.

SELECT RADIANS('Cat');

Result:

+----------------+
| RADIANS('Cat') |
+----------------+
|              0 |
+----------------+