ASIN() function
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 |