Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## ACOS

> Returns the arccosine of `expression`.

> #### Syntax

>     ACOS ( expression )

> Example

> In this example, which illustrates two ways to use the `ACOS` function, the first `SELECT` statement returns the arcosine in radians, and the second returns the arcosine in degrees:

>     select acos (.5) 'Arccosine in radians' from syscalctable;
>     ARCCOSINE IN RADIANS
>     --------------------
>     1.047197551196598

>     1 record selected

>     select acos (.5) * (180/ pi()) 'Arccosine in degrees' from syscalctable;

>     ARCCOSINE IN DEGREES
>     --------------------
>     59.999999999999993
>     1 record selected

> #### Notes

> - `ACOS` takes the ratio (`expression`) of two sides of a right triangle and returns the corresponding angle. The ratio is the length of the side adjacent to the angle divided by the length of the hypotenuse.

> - The result is expressed in radians and is in the range -Pi/2 to Pi/2 radians. To convert degrees to radians, multiply degrees by Pi/180. To convert radians to degrees, multiply radians by 180/Pi.

> - The expression must be in the range -1 to 1.

> - The expression must evaluate to an approximate numeric data type.

> ##### Compatibility

> ODBC compatible

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095