Purpose
This function returns the tangent of an angle.
Syntax
TAN(x)
Parameters
x is a numeric data type or an expression that can be implicitly converted to a numeric data type. It represents an angle in radians.
Return type
If the data type of parameter x is BINARY_FLOAT, this function returns a value of the BINARY_DOUBLE data type. Otherwise, this function returns a value of the same numeric data type as parameter x.
Examples
Calculate the tangent of 0 and 135 degrees.
obclient> SELECT TAN(0),TAN(135*3.1415926/180) FROM DUAL;
+--------+-------------------------------------------+
| TAN(0) | TAN(135*3.1415926/180) |
+--------+-------------------------------------------+
| 0 | -1.00000008038469308854331997429109563738 |
+--------+-------------------------------------------+
1 row in set