Progress
SQL-92
Guide and Reference


ASIN Function

Returns the arcsine of expression.

SYNTAX

ASIN ( expression ) 

EXAMPLE

The following example 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 syscalctable;
 
ARCSINE IN DEGREES
------------------- 
90.000000000000000
 
1 record selected
 
 
select asin (1) ’Arcsine in radians’ from 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

COMPATIBILITY

ODBC Compatible


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