RADIANS() Function in MySQL
RADIANS() function in MySQL is used to convert the degree values into radians. The formula for converting degree to radian is :
180 degrees = π radian
Syntax :
RADIANS(X)
Parameter : This method accepts only one parameter.
X : The degree value which we convert to radian.
Returns : It returns equivalent degree values into radians.
Example-1 :
Finding Radians Value for 0 degree using RADIANS Function.
SELECT RADIANS(0) AS Radian_Value;
Output :
Radian_Value |
---|
0 |
Example-2 :
Finding Radians Value for 180 degree using RADIANS Function.
SELECT RADIANS(180) AS Radian_Value;
Output :
Radian_Value |
---|
3.141592653589793 |
Example-3 :
Finding Radians Value for -90 degree using RADIANS Function.
SELECT RADIANS(-90) AS Radian_Value;
Output :
Radian_Value |
---|
-1.5707963267948966 |
Example-4 :
Using RADIANS Function to convert radian from a degree for a column data. To demonstrate, let us create a table named Polygon.
CREATE TABLE Polygon ( Shape VARCHAR(100) NOT NULL, Sides INT NOT NULL, Sum_of_Interior_Angles DECIMAL(10, 2) NOT NULL, Each_Angle DECIMAL(10, 2) NOT NULL, PRIMARY KEY(Sides) );
Now, insert some data to the Polygon table –
INSERT INTO Polygon(Shape, Sides, Sum_of_Interior_Angles, Each_Angle) VALUES ('Triangle', 3, 180, 60), ('Quadrilateral', 4, 360, 90), ('Pentagon', 5, 540, 108), ('Hexagon', 6, 720, 120), ('Heptagon', 7, 900, 128.57), ('Octagon', 8, 1080, 135), ('Nonagon', 9, 1260, 140), ('Decagon', 10, 1440, 144);
So, the Polygon Table is –
SELECT * FROM Polygon;
Shape | Sides | Sum_of_Interior_Angles | Each_Angle |
---|---|---|---|
Triangle | 3 | 180.00 | 60.00 |
Quadrilateral | 4 | 360.00 | 90.00 |
Pentagon | 5 | 540.00 | 108.00 |
Hexagon | 6 | 720.00 | 120.00 |
Heptagon | 7 | 900.00 | 128.57 |
Octagon | 8 | 1080.00 | 135.00 |
Nonagon | 9 | 1260.00 | 140.00 |
Decagon | 10 | 1440.00 | 144.00 |
We can see that sum of interior angles and each angle of the polygon are given in degrees. Now we will convert these into radians with the help of RADIAN Function.
SELECT Shape, Sides, RADIANS(Sum_of_Interior_Angles) AS Sum_of_Interior_Angles_InRadian, RADIANS(Each_Angle) AS Each_Angle_InRadian FROM Polygon;
Output :
Shape | Sides | Sum_of_Interior_Angles_InRadian | Each_Angle_InRadian |
---|---|---|---|
Triangle | 3 | 3.141592653589793 | 1.0471975511965976 |
Quadrilateral | 4 | 6.283185307179586 | 1.5707963267948966 |
Pentagon | 5 | 9.42477796076938 | 1.8849555921538759 |
Hexagon | 6 | 12.566370614359172 | 2.0943951023931953 |
Heptagon | 7 | 15.707963267948966 | 2.2439698192891093 |
Octagon | 8 | 18.84955592153876 | 2.356194490192345 |
Nonagon | 9 | 21.991148575128552 | 2.443460952792061 |
Decagon | 10 | 25.132741228718345 | 2.5132741228718345 |
So, here the sum of an interior angle, and each angle are converted to equivalent radian value.
Contact Us