ACOS() function
The output is arc cos of X or the value for which COS() is X This function only 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 ACOS(0);// Output 1.5707963267948966 SELECT ACOS(1); // Output is 0 SELECT ACOS(-2); // Output is NULL Using ROUND() with ACOS()SELECT ROUND(ACOS(0),2);// Output is 1.57We are getting outputs in radian, so to change the value to degree we will use DEGREES() ACOS() with DEGREES()SELECT DEGREES(ACOS(0)); // Ouput is 90 SELECT DEGREES(ACOS(0)); // Output is 90 SELECT DEGREES(ACOS(-1)); // Output is 180
This article is written by plus2net.com team.
![]() ▼ More on Math functions in SQL |