SQLite TAN() Function
The SQLite TAN() function returns trigonometric tangent of an angle (angle should be in radians).
Syntax
TAN(x)
Parameters
x |
Required. Specify the angle in radian. |
Return Value
Returns the trigonometric tangent of an angle.
Example 1:
The example below shows the usage of TAN() function.
SELECT TAN(0); Result: 0.0 SELECT TAN(1); Result: 1.5574077246549 SELECT TAN(-1); Result: -1.5574077246549 SELECT TAN(2); Result: -2.18503986326152 SELECT TAN(-2); Result: 2.18503986326152 SELECT TAN(PI()); Result: -1.22464679914735e-16
Example 2:
Consider a database table called Sample with the following records:
Data | x |
---|---|
Data 1 | -10 |
Data 2 | -5 |
Data 3 | 0 |
Data 4 | 5 |
Data 5 | 10 |
The statement given below can be used to calculate the trigonometric tangent value of column x.
SELECT *, TAN(x) AS TAN_Value FROM Sample;
This will produce the result as shown below:
Data | x | TAN_Value |
---|---|---|
Data 1 | -10 | -0.648360827459087 |
Data 2 | -5 | 3.38051500624659 |
Data 3 | 0 | 0.0 |
Data 4 | 5 | -3.38051500624659 |
Data 5 | 10 | 0.648360827459087 |
❮ SQLite Functions