SQL SERVER ACOS Formula

SQL SERVER ACOS Formula

--HI VIEWERS, TODAY WE ARE LOOKING AT THE A COSINE FUNCTION,
-- WHICH NEEDS TO USE A NUMBER BETWEEN -1 AND 1 (>-1 AND ,=1)
-- IN ORDER TO DISPLAY A VALID NON-ERRONOUS VALUE.

-- LET US BEGIN

-- THE VALUE IS 3.14

-- LET'S TRY ANOTHER ONE

-- THE VALUE DISPLAYED IS ZERO

-- LET'S TRY ANOTHER ONE

--THE VALUE FOR THE NEGATIVE NUMBER IS HIGHER THAN THE VALUE FOR THE POSITIVE ACOS NUMBER

-- THAT IS IT.

SELECT ACOS(-1);

SELECT ACOS(1);

SELECT ACOS(-0.9);

SELECT ACOS(0.9);

9

Figure 2 ACOS