Previous Next JavaScript must be enabled to correctly display this content

## arc sine function

The `asin` function is an inverse trigonometric function. The `asin` function returns the arc sine (inverse of sine) of the input expression.

Syntax:

    double asin(n)

Semantics:

- n: The argument n is an expression that resolves to a number.
- return type: double.

  The resultant angle is expressed in radians and is in the range -pi/2 through pi/2 with the following exceptions:

  - Returns a NULL value in the following cases:
    - n resolves to a NULL value
    - n does not resolve to a number
  - Returns NaN in the following cases:
    - n resolves to NaN
    - absolute value of n is greater than one
    - n resolves to positive/negative infinity
  - Results in a zero with the same sign as n, when n is zero.

Example 12-73 arc sine function

    SELECT asin(n) FROM Archery

Value of n | Output
--- | ---
1 | 1.5707963267948966
sqrt(3)/2 | 1.0471975511965976
0.5 | 0.5235987755982989
-1 | -1.5707963267948966