ACOS returns the arc cosine of the specified number.
The value returned is an angle measured in radians.
ACOS accepts values between -1 to 1. Any other value generates an error.
This example returns the arc cosine of the specified values.
SELECT ACOS(1) AS '1',
ACOS(0) AS '0',
ACOS(-1) AS '-1'
| 1 | 0 | -1 |
|---|---|---|
| 0 | 1.5707963267949 | 3.14159265358979 |
Note: The second value is π/2 (1.57) and the last value is π (3.14)
Syntax of the ACOS function.
ACOS(number)
number -- a value between -1 and 1.
