Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

ASIN function (ODBC compatible)

Syntax

ASIN ( expression )

Description

The scalar function ASIN returns the arcsine of expression.

Example

select asin (1) * (180/ pi()) 'Arcsine in degrees' from syscalctable;

ARCSINE IN DEGRE

----------------

90.000000000000000

1 record selected

select asin (1) 'Arcsine in radians' from syscalctable;

ARCSINE IN RADIA

----------------

1.570796326794897

1 record selected

Notes

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.

  • Expression must be in the range -1 to 1.
  • Expression must evaluate to an approximate numeric data type.

TOCIndex