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