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

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

ASIN() function to get arc sin of any value

ASIN() with DEGREES()

Subhendu Mohapatra