ATAN() function
SELECT ATAN( X )
The output is arc tangent cos of X. This is the value for which tangent is X
Let us strat with some known output of ATAN().
SELECT ATAN(0);// Output 0
SELECT ATAN(1); // Output is 0.785398163397448
SELECT ATAN(-2); // Output is -1.10714871779409
Using ROUND() with ATAN()
SELECT ROUND(ATAN(-2),2);// Output is 1.11
We are getting outputs in radian, so to change the value to degree we will use DEGREES()
ATAN() with DEGREES()
SELECT DEGREES(ATAN(0)); // Ouput is 0
SELECT DEGREES(ATAN(1)); // Output is 45
SELECT DEGREES(ATAN(-1)); // Output is -45
SIN() function
This article is written by plus2net.com team.
plus2net.com
▼ More on Math functions in SQL
| 
SQL Video Tutorials