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 & 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

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

Using ROUND() with ATAN2()

Subhendu Mohapatra