DEGREES

描述

输入一个 double 类型的浮点数，由弧度转换为角度。

• 当参数为 NULL 时，返回 NULL

语法

DEGREES(<a>)

参数

参数	说明
<a>	需要由弧度转换为角度的值

返回值

参数 a 的角度

• 当参数为 NULL 时，返回 NULL

特殊情况

• 当 a 为 NaN，返回 NaN
• 当 a 为正无穷（Infinity），返回 Infinity
• 当 a 为负无穷（-Infinity），返回 -Infinity
• 当 a 为 NULL，返回 NULL

举例

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                      |
+--------------------------------+