ACOS to get arc cos of any value using MySQL query

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

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

This article is written by plus2net.com team. https://www.plus2net.com

plus2net.com