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:
SELECT asin(n) FROM Archery
Value of n | Output |
---|---|
1 | 1.5707963267948966 |
sqrt(3)/2 | 1.0471975511965976 |
0.5 | 0.5235987755982989 |
-1 | -1.5707963267948966 |