The ACOS function returns the arc cosine of a specified number.
The specified number is the cosine, in radians, of the angle
that you want. The specified number must be a DOUBLE
- If the specified number is NULL, the result of this function is NULL.
- If the absolute value of the specified number is greater than 1, an exception
is returned that indicates that the value is out of range (SQL state 22003).
The returned value, in radians, is in the range of zero (0) to pi.
The data type of the returned value is a DOUBLE PRECISION number.