ASIN
A function that calculates the inverse sine (arc sine). The result is a number in the interval [-π/2, +π/2].
Syntax
sql
ASIN(expr)Argument
expr: A real number between -1.0 and +1.0 or an argument of another data type that can be converted to a numeric data type.
Return Value
A DECIMAL value in radians (not degrees) in the range [-π/2, +π/2], corresponding to the arc sine value of the argument.
Example
sql
SELECT asin(NULL), asin(0), asin('0'), asin(0.7425), asin(0.61), asin(-0.335);+-------------+---------+-----------+--------------+------------+--------------+
| ASIN(NULL) | ASIN(0) | ASIN('0') | ASIN(0.7425) | ASIN(0.61) | ASIN(-0.335) |
+-------------+---------+-----------+--------------+------------+--------------+
| NULL | 0 | 0 | 0.83... | 0.656... | -0.341... |
+-------------+---------+-----------+--------------+------------+--------------+