DEGREES

Description

Input a double-precision floating-point number and convert it from radians to degrees.

• When the parameter is NULL, return NULL.

Syntax

DEGREES(<a>)

Parameters

parameter	explain
<a>	The value that needs to be converted from radians to degrees.

Return Value

The angle of parameter a.

• When the parameter is NULL, return NULL.

Special Cases

• When a is NaN, returns NaN
• When a is positive infinity, returns Infinity
• When a is negative infinity, returns -Infinity
• When a is NULL, returns NULL

Examples

select degrees(3.14),degrees(1),degrees(-1),degrees(NULL)

+-------------------------------+----------------------------+-----------------------------+---------------+
| degrees(cast(3.14 as DOUBLE)) | degrees(cast(1 as DOUBLE)) | degrees(cast(-1 as DOUBLE)) | degrees(NULL) |
+-------------------------------+----------------------------+-----------------------------+---------------+
|             179.9087476710785 |          57.29577951308232 |          -57.29577951308232 |          NULL |
+-------------------------------+----------------------------+-----------------------------+---------------+

select degrees(cast('nan' as double));

+-------------------------------+
| degrees(cast('nan' AS DOUBLE))|
+-------------------------------+
| NaN                           |
+-------------------------------+

select degrees(cast('inf' as double));

+-------------------------------+
| degrees(cast('inf' AS DOUBLE))|
+-------------------------------+
| Infinity                      |
+-------------------------------+

select degrees(cast('-inf' as double));

+--------------------------------+
| degrees(cast('-inf' AS DOUBLE))|
+--------------------------------+
| -Infinity                      |
+--------------------------------+