Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## ASIN

> Returns the arcsine of `expression`.

> #### Syntax

>     ASIN ( expression )

> Example

> In the following example, which shows how to use the `ASIN` function, the first `SELECT` statement returns the arcsine in degrees, and the second returns the arcsine in radians:

>     SELECT ASIN (1) * (180/ pi()) 'Arcsine in degrees' FROM
>     SYSPROGRESS.SYSCALCTABLE;

>     ARCSINE IN DEGREES
>     -------------------
>     90.000000000000000

>     1 record selected

>     SELECT ASIN (1) 'Arcsine in radians' FROM SYSPROGRESS.SYSCALCTABLE;

>     ARCSINE IN RADIANS
>     ------------------
>     1.570796326794897

>     1 record selected

> `ASIN` takes the ratio (`expression`) of two sides of a right triangle and returns the corresponding angle. The ratio is the length of the side opposite 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.

> #### Notes

> - 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