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 NULL
We are getting outputs in radian, so to change the value to degree we will use DEGREES()


SELECT DEGREES(ASIN(1)); // Ouput is 90
SELECT DEGREES(ASIN(0)); // Output is 0 
SELECT DEGREES(ASIN(-1)); // Output is -90

Post your comments , suggestion , error , requirements etc here .

SQL Video Tutorials

We use cookies to improve your browsing experience. . Learn more
HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
©2000-2021 All rights reserved worldwide Privacy Policy Disclaimer