ATAN() function
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.11We 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
This article is written by plus2net.com team.
![]() ▼ More on Math functions in SQL |