ACOS() function to get arc cos of any value
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
Syntax
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.
We 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
← SQL Math References
COS() →
SIN() function
← Subscribe to our YouTube Channel here
This article is written by plus2net.com team.
https://www.plus2net.com
plus2net.com