ATAN to get arc tangent of a value using MySQL query

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)); // Output is 0
SELECT DEGREES(ATAN(1)); // Output is 45 
SELECT DEGREES(ATAN(-1)); // Output is -45

Syntax

SELECT ATAN( X )

The output is arc tangent cos of X. This is the value for which tangent is X

SQL Math References SIN() function COS()

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author Watch on YouTube

Connect:

Subscribe to our YouTube Channel here

ATAN() function

Using ROUND() with ATAN()

ATAN() with DEGREES()

Subhendu Mohapatra