PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References
PostgreSQL Tutorial PostgreSQL Advanced PostgreSQL Database Account Management PostgreSQL References

PostgreSQL DEGREES() Function



The PostgreSQL DEGREES() function returns an angle measured in radians to an approx. equivalent angle measured in degrees.

Syntax

DEGREES(x)

Parameters

x Required. Specify an angle in radians.

Return Value

Returns the angle measured in degrees.

Example 1:

The example below shows the usage of DEGREES() function.

SELECT DEGREES(0);
Result: 0

SELECT DEGREES(1);
Result: 57.29577951308232

SELECT DEGREES(2);
Result: 114.59155902616465

SELECT DEGREES(3);
Result: 171.88733853924697

SELECT DEGREES(PI()/3);
Result: 59.99999999999999

SELECT DEGREES(PI()/2);
Result: 90

SELECT DEGREES(PI());
Result: 180

Example 2:

Consider a database table called Sample with the following records:

Datax
Data 10
Data 21
Data 32
Data 43
Data 54

The statement given below can be used to convert the records of column x (containing values expressed in radians) into degrees.

SELECT *, DEGREES(x) AS DEGREES_Value FROM Sample;

This will produce the result as shown below:

DataxDEGREES_Value
Data 100
Data 2157.29577951308232
Data 32114.59155902616465
Data 43171.88733853924697
Data 54229.1831180523293

❮ PostgreSQL Functions