SQL DEGREES()

The DEGREES() function in SQL is a mathematical function used to convert a value expressed in radians to its equivalent in degrees. This function is available in various SQL dialects, including SQL Server, MySQL, and Oracle.

Note: Functions RADIANS() and PI() are closely related to DEGREES().

Syntax

 DEGREES(number)

Parameters:

• number: A numeric expression in radians to be converted to degrees.

Return value:

Returns the angle in degrees as a numeric value.

Example 1

This example converts a specific radian value to degrees:

Select DEGREES(1.0) as degrees_value;

Copy to clipboard
Copy to clipboard

The output:

Example 2

This query converts PI*2 radians to degrees:

SELECT DEGREES(PI()*2) as degrees_off_of_pi;

Copy to clipboard
Copy to clipboard

The output: