Skip to main content

ASINH

Description

Returns the hyperbolic arc sine of x.

Syntax

ASINH(<x>)

Parameters

ParameterDescription
<x>The value for which the hyperbolic arc sine value is to be calculated

Return Value

The asinh value of parameter x.

Special Cases

  • When x is NaN, returns NaN
  • When x is positive infinity, returns Infinity
  • When x is negative infinity, returns -Infinity
  • When x is +0.0, returns 0
  • When x is -0.0, returns -0
  • Very large magnitudes may overflow to Infinity/-Infinity (for example, ±1e308)
  • When x is NULL, returns NULL

Example

select asinh(0.0);
+------------+
| asinh(0.0) |
+------------+
| 0 |
+------------+
select asinh(1.0);
+-------------------+
| asinh(1.0) |
+-------------------+
| 0.881373587019543 |
+-------------------+
select asinh(-1.0);
+--------------------+
| asinh(-1.0) |
+--------------------+
| -0.881373587019543 |
+--------------------+
select asinh(cast('nan' as double));
+------------------------------+
| asinh(cast('nan' AS DOUBLE)) |
+------------------------------+
| NaN |
+------------------------------+
select asinh(cast('inf' as double));
+------------------------------+
| asinh(cast('inf' AS DOUBLE)) |
+------------------------------+
| Infinity |
+------------------------------+
select asinh(cast('-inf' as double));
+-------------------------------+
| asinh(cast('-inf' AS DOUBLE)) |
+-------------------------------+
| -Infinity |
+-------------------------------+