ACOS is a trigonometric function that returns the arc cosine of a number.
The return value is in radians and is between 0 and PI.
Syntax
ACOS(number)
Arguments
- number
-
The input parameter is a
DOUBLE PRECISIONnumber.
Return type
DOUBLE PRECISION
Examples
To return the arc cosine of -1, use the following example.
SELECT ACOS(-1);
+-------------------+
| acos |
+-------------------+
| 3.141592653589793 |
+-------------------+To convert the arc cosine of .5 to the equivalent number of
degrees, use the following example.
SELECT (ACOS(.5) * 180/(SELECT PI())) AS degrees;
+-------------------+
| degrees |
+-------------------+
| 60.00000000000001 |
+-------------------+