COT
描述
返回 x 的余切值,x 为弧度值,仅支持输入输出为double。输入null值时会返回null。
语法
COT(<x>)
参数
参数 | 说明 |
---|---|
<x> | 需要被计算余切值的值 |
返回值
返回一个 Double 类型的值表示 x 的余切值。
特殊情况
- 当
x
为NaN
,返回NaN
- 当
x
为正无穷或负无穷(±Infinity
),返回NaN
- 当
x
为NULL
,返回NULL
举例
select cot(1),cot(2),cot(1000);
+--------------------+----------------------+--------------------+
| cot(1) | cot(2) | cot(1000) |
+--------------------+----------------------+--------------------+
| 0.6420926159343306 | -0.45765755436028577 | 0.6801221323348698 |
+--------------------+----------------------+--------------------+
输入null值。
select cot(null);
+--------------------+
| cot(null) |
+--------------------+
| NULL |
+--------------------+
select cot(cast('nan' as double));
+----------------------------+
| cot(cast('nan' AS DOUBLE)) |
+----------------------------+
| NaN |
+----------------------------+
select cot(cast('inf' as double));
+----------------------------+
| cot(cast('inf' AS DOUBLE)) |
+----------------------------+
| NaN |
+----------------------------+
select cot(cast('-inf' as double));
+-----------------------------+
| cot(cast('-inf' AS DOUBLE)) |
+-----------------------------+
| NaN |
+-----------------------------+