| ASIN | Syntax: | ASIN(Number) | | Return value: | FLOAT | | Function type: | Numeric function | |
|
|
The ASIN() function returns the arc-sine (inverse sine) of "Number". "Number" is the sine of a radians.
The DEGREES() function can be used to calculate the angle from a radians.
Returns NULL if "Number" is not in a valid sine range -1 to 1. |
SQL Examples for the ASIN function |
| select asin(0.7071067811865476);
select degrees(asin(0.7071067811865476));
select asin(-0.7071067811865476);
select degrees(asin(-0.7071067811865476));
select asin(1);
select degrees(asin(1));
select asin(2);
|
|
| asin(0.7071067811865476) |
|---|
| double(23) |
|---|
| 0.7853981633974484 |
|
|
| degrees(asin(0.7071067811865476)) |
|---|
| double(23) |
|---|
| 45.00000000000001 |
|
|
| asin(-0.7071067811865476) |
|---|
| double(23) |
|---|
| -0.7853981633974484 |
|
|
| degrees(asin(-0.7071067811865476)) |
|---|
| double(23) |
|---|
| -45.00000000000001 |
|
|
| asin(1) |
|---|
| double(23) |
|---|
| 1.5707963267948966 |
|
|
| degrees(asin(1)) |
|---|
| double(23) |
|---|
| 90 |
|
| |
|
|
| The examples were created with the MyWAY SQL manager: |
How to use the ASIN() function in MySQL and MariaDB databases |
| The ASIN() function in MySQL and MariaDB is commonly used in trigonometric calculations and applications involving angles. An angle associated with a particular sine value may need to be determined. |
|
Further MySQL und MariaDB SQL Numeric functions |
|
