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