SIN

描述

计算参数的正弦值

语法

SIN(<a>)

参数

参数	说明
<a>	浮点数，要计算参数的弧度值

返回值

参数 <a> 的正弦值，弧度制表示。

特殊情况

• 当 x 为 NaN，返回 NaN
• 当 x 为正无穷或负无穷（±Infinity），返回 NaN
• 当 x 为 NULL，返回 NULL

语法

SIN(<x>)

参数

参数	说明
<x>	弧度值

返回值

返回浮点数。特殊情况：

• 当 x is NULL 时，返回 NULL.

举例

select sin(1);

+------------------------+
| sin(cast(1 as DOUBLE)) |
+------------------------+
|     0.8414709848078965 |
+------------------------+

select sin(0);

+------------------------+
| sin(cast(0 as DOUBLE)) |
+------------------------+
|                    0.0 |
+------------------------+

select sin(Pi());

+------------------------------------+
| sin(pi())                          |
+------------------------------------+
| 0.00000000000000012246467991473532 |
+------------------------------------+

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

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

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

+----------------------------+
| sin(cast('inf' AS DOUBLE)) |
+----------------------------+
| NaN                        |
+----------------------------+

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

+-----------------------------+
| sin(cast('-inf' AS DOUBLE)) |
+-----------------------------+
| NaN                         |
+-----------------------------+