跳到主要内容
最后于 更新

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