ACOS
Description
Returns the arc cosine of x, or NULL if x is not in the range -1 to 1.
Syntax
ACOS(<x>)
Parameters
| Parameter | Description |
|---|---|
<x> | The value for which the acos value is to be calculated |
Return Value
The acos value of parameter x.
Example
select acos(1);
+-----------+
| acos(1.0) |
+-----------+
| 0 |
+-----------+
select acos(0);
+--------------------+
| acos(0.0) |
+--------------------+
| 1.5707963267948966 |
+--------------------+
select acos(-2);
+------------+
| acos(-2.0) |
+------------+
| nan |
+------------+