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 Popular Tutorials

Order by displaying records Records Between two date ranges Some of the records by LIMIT query SQL SUM of data in columns

✖

We use cookies to improve your browsing experience. . Learn more

HTML

MySQL

PHP

JavaScript

ASP

Photoshop

Articles

FORUM . Contact us