TANH
説明
xの双曲線正接を返します。
構文
TANH(<x>)
パラメータ
| パラメータ | 説明 |
|---|---|
<x> | 双曲線正接を計算する値 |
戻り値
パラメータ x の双曲線正接。
特殊なケース
xが NaN の場合、NaN を返すxが正の無限大の場合、1 を返すxが負の無限大の場合、-1 を返すxが NULL の場合、NULL を返す
例
select tanh(0),tanh(1);
+-------------------------+-------------------------+
| tanh(cast(0 as DOUBLE)) | tanh(cast(1 as DOUBLE)) |
+-------------------------+-------------------------+
| 0 | 0.7615941559557649 |
+-------------------------+-------------------------+
select tanh(cast('nan' as double));
+-----------------------------+
| tanh(cast('nan' AS DOUBLE)) |
+-----------------------------+
| NaN |
+-----------------------------+
select tanh(cast('inf' as double));
+-----------------------------+
| tanh(cast('inf' AS DOUBLE)) |
+-----------------------------+
| 1 |
+-----------------------------+
select tanh(cast('-inf' as double));
+------------------------------+
| tanh(cast('-inf' AS DOUBLE)) |
+------------------------------+
| -1 |
+------------------------------+