ASIN to get arc sin of any value of the range +1 to -1 using MySQL query

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

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.

SQL Math References TAN() to get tangent sin()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

ASIN() function to get arc sin of any value

ASIN() with DEGREES()

Subhendu Mohapatra