ACOS() function
SELECT ACOS( X )
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.57
We 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
SIN() function
This article is written by plus2net.com team.
plus2net.com
▼ More on Math functions in SQL
| 
SQL Video Tutorials