MySQL TAN() Function

Basically, the TAN() function in MySQL is used to give back the tangent of a mentioned number.
In any kind of right-angle triangle, the tangent of an angle is the length of the opposite side divided by the length of the adjacent side. Similarly, the tangent of y can also be defined as the sine of y divided by the cosine of y, where y is the specified angle.

Syntax of the MySQL TAN() function:

The syntax of the MySQL TAN() function is given as follows:
TAN(num);

Parameters or arguments used in MySQL TAN() function:

Only one parameter is accepted by the TAN() function in MySQL, which is given as follows:

Number: It is the number which we want to calculate the tangent value of the number.

Returns: It will return the tangent of that mentioned number.

Application used for TAN() function:

The TAN() function can be used in the given below MySQL 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

Examples of MySQL TAN() function:

Now we will look into some MySQL TAN() function examples and will explore how to use the TAN function in MySQL.

Example 1:
Here, we will derive the tangent value of 1 using the TAN() function in MySQL.

SELECT TAN( 1) as TAN_ value ;

Output:

TAN_ value
1.5574077246549023
1 row in set (0.00 sec)

Example 2:

Here, we will derive the tangent value of 0 using the TAN() function in MySQL.

SELECT TAN(0) as TAN_ value ;

Output:

TAN_ value
0
1 row in set (0.00 sec)

Example 3:

Now we will derive the tangent value of -3 using the TAN() function in MySQL.

SELECT TAN(-3) as TAN_ value ;

Output:

TAN_ value
0.1425465430742778
1 row in set (0.00 sec)

Example 4:

Now we will derive the tangent value of 3 using the TAN() function in MySQL.

SELECT TAN(3) as TAN_ value ;

Output:

TAN_ value
-0.1425465430742778
1 row in set (0.00 sec)

Example 5:

Now we will derive the tangent value of 0.75 using the TAN() function in MySQL.

SELECT TAN(0.75) as TAN_ value ;

Output:

TAN_ value
0.9315964599440725
1 row in set (0.00 sec)

Example 6:

Now we will derive the tangent value of 8 using the TAN() function in MySQL.

SELECT TAN(8) as TAN_ value ;

Output:

TAN_ value
-6.799711455220379
1 row in set (0.00 sec)

Example 7:

You can also pass the pi() function as a value to the TAN() function, as shown below:

SELECT TAN(pi()) as TAN_ value;

Output:

TAN_ value
-1.2246467991473532e-16
1 row in set (0.00 sec)

Example 8:

Following is another example of the TAN() function in MySQL in which we will derive the tangent value of -16.

SELECT TAN(-16) as TAN_ value ;

Output:

TAN_ value
-0.3006322420239034
1 row in set (0.00 sec)

Application of MySQL TAN() function:

This function is used to return the tangent of a mentioned number.

Summary:

In the above context, we have learned how we can use the TAN () function in MySQL to calculate the tangent value of the specified number.