PostgreSQL RADIANS() Function
The PostgreSQL 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.
SELECT RADIANS(0); Result: 0 SELECT RADIANS(30); Result: 0.5235987755982988 SELECT RADIANS(60); Result: 1.0471975511965976 SELECT RADIANS(90); Result: 1.5707963267948966 SELECT RADIANS(180); Result: 3.141592653589793 SELECT RADIANS(-90); Result: -1.5707963267948966 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 |
❮ PostgreSQL Functions