The ASIN function returns the arc sine of the specified value.
The value returned is an angle measured in radians.
ASIN accepts values between -1 and 1. Any other value generates an error.
This example returns the arc sine of the specified values.
SELECT ASIN(1) AS '1',
ASIN(0) AS '0',
ASIN(-1) AS '-1'
| 1 | 0 | -1 |
|---|---|---|
| 1.5707963267949 | 0 | -1.5707963267949 |
Note: The first and last values are π/2 (1.57)
Syntax of the ASIN function.
ASIN(number)
number -- a value between -1 and 1.
