Blog

In this guide, we will explain how to use the MySQL ATAN2 function with syntax and examples.

Description

The MySQL ATAN2 function returns the arc tangent of n and m.

Syntax

The syntax for the ATAN2 function is:

ATAN2( n, m )

Parameters or Arguments

n, m

Values used to calculate the arc tangent of two values.

Note

• The signs of n and m are used to determine the quadrant for the result from the ATAN2 function.

Applies To

The ATAN2 function can be used in the following versions :

• MySQL 5.7, MySQL 5.6, MySQL 5.5, MySQL 5.1, MySQL 5.0, MySQL 4.1, MySQL 4.0, MySQL 3.23

Example

Let’s look at some ATAN2 function examples and explore how to use the ATAN2 function.

For example:

mysql> SELECT ATAN2(0.75, 1);
Result: 0.6435011087932844

mysql> SELECT ATAN2(-0.9, 2);
Result: -0.4228539261329407

mysql> SELECT ATAN2(PI(), 2);
Result: 1.0038848218538872

Next Topic : Click Here