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

🎥 Join me live on YouTube

Passionate about coding and teaching, I publish practical tutorials on PHP, Python, JavaScript, SQL, and web development. My goal is to make learning simple, engaging, and project‑oriented with real examples and source code.

Subscribe to our YouTube Channel here

ATAN() function

Using ROUND() with ATAN()

ATAN() with DEGREES()

Subhendu Mohapatra