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 start 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)); // Output is 90 SELECT DEGREES(ASIN(0)); // Output is 0 SELECT DEGREES(ASIN(-1)); // Output is -90 ![]()
This article is written by plus2net.com team.
https://www.plus2net.com
![]() ▼ More on Math functions in SQL |