ACOS scalar function
The ACOS function returns the arc cosine of the argument as an angle, expressed in radians. The ACOS and COS functions are inverse operations.
The schema is SYSIBM.
The argument must be an expression that returns the value of any built-in numeric data type except for DECFLOAT. The value must be greater than or equal to -1 and less than or equal to 1. If the argument is not a double precision floating-point number, it is converted to one for processing by the function.
The result of the function is a double precision floating-point number.
The result can be null; if the argument is null, the result is the null value.
Example: Assume that host variable ACOSINE is
DECIMAL(10,9) with a value of 0.070737202. The following statement:
SELECT ACOS(:ACOSINE)
FROM SYSIBM.SYSDUMMY1;
returns a double precision
floating-point number with an approximate value of 1.49.