MySQL ATAN() Function

 The ATAN() function in MySQL returns the arc tangent (inverse of tangent) of a number, which is the angle in radians whose tangent is the given number. It is used to find the angle whose tangent is a given number, typically between -π/2 and π/2 (in radians).

Syntax:

ATAN(X)

• X: A numeric expression representing the tangent of an angle. It can be any valid numeric expression.

Return Value:

• Returns the angle in radians.
• The result will be in the range -π/2 to π/2.

Example:

1. Single argument example:

SELECT ATAN(1);

This will return the arc tangent of 1, which is approximately 0.785398 radians (π/4).

2. Negative value example:

SELECT ATAN(-1);

This will return the arc tangent of -1, which is approximately -0.785398 radians (-π/4).

Additional Notes:

• To convert the result from radians to degrees, you can use the DEGREES() function:

SELECT DEGREES(ATAN(1));

This will return the result in degrees (45 degrees for ATAN(1)).

Let me know if you need further clarification or examples!