RADIANS Function in SQL

The RADIANS numeric function of Structured Query Language returns the radians value of the specified degree.

Syntax of RADIANS Function

Syntax1: This syntax uses the RADIANS function with the column name of the SQL table:

In this first syntax, we have to specify the name of that column on which we want to execute the RADIANS function for converting the degree value into radians.

Syntax2: This syntax uses the RADIANS function with the number:

Examples of RADIANS Function

Example 1: This example returns the Radians value of the specified number (degree):

Output:

Radiansvalue_of_360
6.283

Example 2: This example returns the Radians value of the specified number:

Output:

Radiansvalue_of_180
3.14159

Example 3: This example returns the Radians value of 90 degree:

Output:

Radiansvalue_of_90
1.57

Example 4: This example returns the Radians value of -45 degree:

Output:

Radiansvalue_of_-45
-0.785

Example 5: This example returns the Radians value of the given expression:

  SELECT RADIANS(180 / 3) AS Radiansvalue_of_Expression;  
<p><strong>Output:</strong></p>
<table class="alt">
<tr>
<th>Radiansvalue_of_Expression</th>
</tr>
<tr>
<td>1.047</td>
</tr>
</table>
<p><strong>Example 6:</strong> This example uses the RADIANS function with the SQL table.</p>
<p>In this example, we will create the new table through which we will perform the RADIANS function on the columns:</p>
<p>The following shows the syntax to create the new table in SQL:</p>
<div class="codeblock"><textarea class="sql" name="code">  CREATE TABLE Name_of_New_Table  (  First_Column_of_table Data Type (character_size of First Column),    Second_Column_of_table Data Type (character_size of the Second column ),    Third_Column_of_table Data Type (character_size of the Third column),    …….,    Last_Column_of_table Data Type (character_size of the Last column)  );    

The following CREATE statement creates the Vehicle_Details table for storing the details of purchasing and selling vehicles:

  CREATE TABLE Vehicle_Details  (  Vehicle_ID INT NOT 80,  Vehicle_Name Varchar(50),  Vehicle_Quantity INT,  Purchasing_Vehicles INT,  Selling_Vehicles INT,  Release_Date Date,   Vehicle_Rating INT  );  

The following multiple INSERT queries insert the records of vehicles with their quantity, and number of selling and purchasing vehicles into the Vehicle_Details table:

  INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (140, P1, 290, 45, 80, 2022-04-30, 80);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (190, P4, 15, 180, 180, 2022-01-28, 90.85);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (145, P2, 20, 270, 290, 2022-02-18, 80);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (90, P7, 10, 360, 80, 2021-12-25, 180);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (45, P6, 35, 45, -15, 2021-10-15, 80);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (210, P8, 30, 160, -60, 2022-01-28, 95);    INSERT INTO Vehicle_Details (Vehicle_ID, Vehicle_Name, Vehicle_ Quantity Purchasing_Vehicles, Selling_Vehicles, Release_Date, Vehicle_Rating) VALUES (185, P10, 290, 450, 470, 2022-04-11, 80);  

The following SELECT statement displays the inserted records of the above Vehicle_Details table:

Vehicle_ID	Vehicle_Name	Vehicle_Quantity	Purchasing_Vehicles	Selling_Vehicles	Release_Date	Vehicle_Rating
140	P1	290	45	80	2022-04-30	80
190	P4	15	180	180	2022-01-28	90.85
145	P2	20	270	290	2022-02-18	80
90	P7	10	360	80	2021-12-25	180
45	P6	35	45	-15	2021-10-15	80
210	P8	30	160	-60	2022-01-28	95
185	P10	290	450	470	2022-04-11	80

Query 1: The following SELECT query uses the RADIANS function with the Vehicle_ID column of the above Vehicle_Details table:

  SELECT Vehicle_ID, RADIANS(Vehicle_ID) AS Radians value_of_Vehicle_ID FROM Vehicle_Details;  

This query shows the Radians value of vehicle id of each vehicle.

Output:

Vehicle_ID	Radians value_of_Vehicle_ID
140	2.4436
190	3.316
145	2.531
90	1.571
45	0.785
210	3.665
185	3.229

Query 2: The following SELECT query uses the RADIANS function with the Purchasing_Vehicles column of the above Vehicle_Details table:

  SELECT Purchasing_Vehicles, RADIANS(Purchasing_Vehicles) AS Radians value_of_PurchasingVehicles FROM Vehicle_Details;  

This query shows the Radians value of purchasing vehicles.

Output:

Purchasing_Vehicles	Radians value_of_PurchasingVehicles
45	0.785
180	3.14159
270	4.712
360	6.28
45	0.785
160	2.793
450	7.854

Query 3: The following SELECT query uses the RADIANS function with the Vehicle_Rating column of the above Vehicle_Details table:

  SELECT RADIANS(Vehicle_Rating) AS Radians value_of_vehiclerating FROM Vehicle_Details;  

This query shows the Radians value of rating of each vehicle from the above table.

Output:

Vehicle_Rating	Radians value_of_vehiclerating
80	1.396
90.85	1.586
80	1.396
180	3.14159
80	1.396
95	1.658
80	1.396

Query 4: The following SELECT query uses the RADIANS function with the and Purchasing_Vehicles and Selling_Vehicles column of the above Vehicle_Details table:

  SELECT Selling_Vehicles, RADIANS(Selling_Vehicles) AS Radians value_of_SellingVehicles FROM Vehicle_Details;  

This query shows the Radians value of selling Vehicles of each vehicle.

Output:

Selling_Vehicles	Radians value_of_SellingVehicles
80	1.396
180	3.14
290	5.061
80	1.396
-15	-0.2618
-60	-1.0472
470	8.203

Next TopicRAND Function in SQL

RADIANS Function in SQL

RADIANS Function in SQL

Syntax of RADIANS Function

Examples of RADIANS Function

ATN2 Function in SQL

TAN Function in SQL

You may also like