DB2 Version 10.1 for Linux, UNIX, and Windows

ACOS scalar function

Returns the arccosine of the argument as an angle expressed in radians.


>>-ACOS--(--expression--)--------------------------------------><

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

This statement returns the approximate value 1.49.