跳到主要内容

SEC

描述

返回 x 的正割值,x 为弧度值,仅支持输入输出为double。输入null值时会返回null。

语法

SEC(<x>)

参数

参数说明
<x>需要被计算正割值的值

返回值

返回一个 Double 类型的值表示 x 的正割值。

特殊情况

  • xNaN,返回 NaN
  • x 为正无穷或负无穷(±Infinity),返回 NaN
  • xNULL,返回 NULL

举例

select sec(1),sec(2),sec(1000);
+--------------------+--------------------+--------------------+
| sec(1) | sec(2) | sec(1000) |
+--------------------+--------------------+--------------------+
| 1.8508157176809255 | -2.402997961722381 | 1.7781600385912715 |
+--------------------+--------------------+--------------------+

输入null值。

select sec(null);
+--------------------+
| sec(null) |
+--------------------+
| NULL |
+--------------------+
select sec(cast('nan' as double));
+---------------------------+
| sec(cast('nan' AS DOUBLE))|
+---------------------------+
| NaN |
+---------------------------+
select sec(cast('inf' as double));
+---------------------------+
| sec(cast('inf' AS DOUBLE))|
+---------------------------+
| NaN |
+---------------------------+
select sec(cast('-inf' as double));
+----------------------------+
| sec(cast('-inf' AS DOUBLE))|
+----------------------------+
| NaN |
+----------------------------+