SQL RADIANS()

The SQL RADIANS() function converts an angle in degrees to its equivalent in radians.

Syntax

RADIANS(angle_in_degrees)

Parameters:

• angle_in_degrees: A numeric expression representing the angle in degrees to be converted.

Return value:

• Returns a numeric value representing the corresponding angle in radians.

Example 1

The following query converts 180 degrees to radians:

SELECT RADIANS(180) AS radians_value;

Copy to clipboard
Copy to clipboard

The output will be:

It shows that 180 degrees is equal to 3.141593 radians.

Note: The exact output may vary slightly depending on the database system’s floating-point precision.

Example 2

Convert a column of degree values to radians:

Suppose there is a table named angles with the following data:

The following query converts this data to radians:

SELECT angle, RADIANS(angle) AS radians_value
FROM angles;

Copy to clipboard
Copy to clipboard

The output will be: