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 strat with some known output of Sin.
SELECT ASIN(0);// Output 0 SELECT ASIN(1); // Output is 1.5707963267948966 SELECT ASIN(-2); // Output is NULLWe are getting outputs in radian, so to change the value to degree we will use DEGREES()
ASIN() with DEGREES()
SELECT DEGREES(ASIN(1)); // Ouput is 90 SELECT DEGREES(ASIN(0)); // Output is 0 SELECT DEGREES(ASIN(-1)); // Output is -90
This article is written by plus2net.com team.
▼ More on Math functions in SQL