ACOS scalar function
Returns the arccosine of the argument as an angle expressed in radians.
The schema is SYSIBM. (The SYSFUN version of the ACOS function continues to be available.)
-
expression
- An expression that returns a value of any built-in numeric data type except for DECFLOAT. The value is converted to a double-precision floating-point number 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 can be null or the database is configured with dft_sqlmathwarn set to YES; the result is the null value if the argument is null.
Example
Assume that the host variable ACOSINE is a DECIMAL(10,9)
host variable with a value of 0.070737202.
SELECT ACOS(:ACOSINE)
FROM SYSIBM.SYSDUMMY1