ACOS function

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

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 |
+-------------------+