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