ATAN2 Mysql function to get arc tangent of the two variables using MySQL query

SELECT ATAN2(8,6); // Output is 0.927295218001612
SELECT ATAN2(0.1,0.3); // Output is 0.321750554396642
SELECT ATAN2(0,0); // Output is 0

Using ROUND() with ATAN2()

SELECT ROUND(ATAN2(5,6),2);// Output is 0.69
SELECT ROUND(ATAN2(-3,-8),2); // Output is -2.78
SELECT ROUND(ATAN2(9,-15),2); // Output is 2.60

Syntax

SELECT ATAN2( X,Y )

Returns arc tangent of X & Y. This is same as ARC Tangent of X/Y
SQL Math References TAN() to get tangent sin()

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

ATAN2() function to get arc tangent of the two variables

Using ROUND() with ATAN2()

Subhendu Mohapatra