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.
- Returns a NULL value in the following cases:
Example 12-72 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 |