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.

Read syntax diagramSkip visual syntax diagramACOS( numeric-expression)

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.