MySQL: ASIN Function
This MySQL tutorial explains how to use the MySQL ASIN function with syntax and examples.
Description
The MySQL ASIN function returns the arc sine of a number.
Syntax
The syntax for the ASIN function in MySQL is:
ASIN( number )
Parameters or Arguments
- number
- The number used to calculate the arc sine.
Note
- The ASIN function will return NULL, if number is not within the range of -1 to 1.
Applies To
The ASIN function can be used in the following versions of MySQL:
- MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23
Example
Let's look at some MySQL ASIN function examples and explore how to use the ASIN function in MySQL.
For example:
mysql> SELECT ASIN(0.75); Result: 0.848062078981481 mysql> SELECT ASIN(0.2); Result: 0.2013579207903308 mysql> SELECT ASIN(-0.9); Result: -1.1197695149986342 mysql> SELECT ASIN(2); Result: NULL
Advertisements