ASIN() function
SELECT ASIN( X )
The output is arc sine of X or the value for which SIN() is X
This function takes input in range of -1 to 1, for any other input the output will be NULL.
Let us start with some known output of Sin.
SELECT ASIN(0);// Output 0
SELECT ASIN(1); // Output is 1.5707963267948966
SELECT ASIN(-2); // Output is NULL
We are getting outputs in radian, so to change the value to degree we will use DEGREES()
ASIN() with DEGREES()
SELECT DEGREES(ASIN(1)); // Output is 90
SELECT DEGREES(ASIN(0)); // Output is 0
SELECT DEGREES(ASIN(-1)); // Output is -90
This article is written by plus2net.com team.
https://www.plus2net.com
plus2net.com
▼ More on Math functions in SQL
|
SQL Video Tutorials