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.57
We are getting outputs in radian, so to change the value to degree we will use DEGREES()


SELECT DEGREES(ACOS(0)); // Output is 90
SELECT DEGREES(ACOS(0)); // Output is 90 
SELECT DEGREES(ACOS(-1)); // Output is 180

SIN() function


* indicates required
Subscribe to plus2net

    Post your comments , suggestion , error , requirements etc here .

    SQL Video Tutorials

    We use cookies to improve your browsing experience. . Learn more
    HTML MySQL PHP JavaScript ASP Photoshop Articles FORUM . Contact us
    ©2000-2022 All rights reserved worldwide Privacy Policy Disclaimer