MySQL Tutorial/Math Numeric Functions/ASIN

ASIN(X) returns the arc sine of X. Returns NULL if X is not in the range -1 to 1.

mysql>
mysql> SELECT ASIN(0.2);
+------------------+
| ASIN(0.2)        |
+------------------+
| 0.20135792079033 |
+------------------+
1 row in set (0.00 sec)
mysql>

SELECT ASIN("foo");

mysql>
mysql>
mysql> SELECT ASIN("foo");
+-------------+
| ASIN("foo") |
+-------------+
|           0 |
+-------------+
1 row in set, 1 warning (0.00 sec)
mysql>
mysql> SHOW WARNINGS;
+---------+------+-----------------------------------------+
| Level   | Code | Message                                 |
+---------+------+-----------------------------------------+
| Warning | 1292 | Truncated incorrect DOUBLE value: "foo" |
+---------+------+-----------------------------------------+
1 row in set (0.00 sec)
mysql>