TAN is a tangent function that accepts number (radian value) as an input parameter and returns the corresponding tangent function calculation result.
Syntax
double|decimal tan(<number>)Parameters
number: Required. You must pass a DOUBLE or DECIMAL type value. When the input is STRING or BIGINT type, it will be implicitly converted to DOUBLE type before calculation.
Return values
Returns DOUBLE or DECIMAL type. The return value varies based on the following rules:
If the value of number is of the DOUBLE or DECIMAL type, a value of the same type is returned.
If the value of number is of the STRING or BIGINT type, a value of the DOUBLE type is returned.
If the value of number is null, null is returned.
Sample data
This section provides sample source data and examples for you to understand how to use the function. In this topic, a table named mf_math_fun_t is created and data is inserted into the table. Sample statements:
create table if not exists mf_math_fun_t(
int_data int,
bigint_data bigint,
double_data double,
decimal_data decimal,
float_data float,
string_data string
);
insert into mf_math_fun_t values
(null, -10, 0.525, 0.525BD, cast(0.525 as float), '10'),
(-20, null, -0.1, -0.1BD, cast(-0.1 as float), '-10'),
(0, -1, null, 20.45BD, cast(-1 as float), '30'),
(-40, 4, 0.89, null, cast(0.89 as float), '-30'),
(5, -50, -1, -1BD, null, '50'),
(-60, 6, 1.5, 1.5BD, cast(1.5 as float), '-50'),
(-1, -70, -7.5, -7.5BD, cast(-7.5 as float),null ),
(-80, 1, -10.2, -10.2BD, cast(-10.2 as float), '-1' ),
(9, -90, 2.58, 2.58BD, cast(2.58 as float), '0'),
(-100, 10, -5.8, -5.8BD, cast(-5.8 as float), '-90');Query data from the mf_math_fun_t table. Sample statement:
select * from mf_math_fun_t;
-- The following result is returned:
+------------+-------------+-------------+--------------+------------+-------------+
| int_data | bigint_data | double_data | decimal_data | float_data | string_data |
+------------+-------------+-------------+--------------+------------+-------------+
| NULL | -10 | 0.525 | 0.525 | 0.525 | 10 |
| -20 | NULL | -0.1 | -0.1 | -0.1 | -10 |
| 0 | -1 | NULL | 20.45 | -1.0 | 30 |
| -40 | 4 | 0.89 | NULL | 0.89 | -30 |
| 5 | -50 | -1.0 | -1 | NULL | 50 |
| -60 | 6 | 1.5 | 1.5 | 1.5 | -50 |
| -1 | -70 | -7.5 | -7.5 | -7.5 | NULL |
| -80 | 1 | -10.2 | -10.2 | -10.2 | -1 |
| 9 | -90 | 2.58 | 2.58 | 2.58 | 0 |
| -100 | 10 | -5.8 | -5.8 | -5.8 | -90 |
+------------+-------------+-------------+--------------+------------+-------------+Examples: static data
--Returns -6.405331196646276.
select tan(30);
--Returns NULL.
select tan(null);Examples: table data
Based on the sample data, calculate the tangent value of the columns. Sample statement:
select tan(bigint_data) as bigint_new, tan(double_data) as double_new, tan(decimal_data) as decimal_new, tan(string_data) as string_new from mf_math_fun_t;The following result is returned.
+----------------------+----------------------+----------------------+----------------------+
| bigint_new | double_new | decimal_new | string_new |
+----------------------+----------------------+----------------------+----------------------+
| -0.6483608274590866 | 0.5792200822893652 | 0.5792200822893652 | 0.6483608274590866 |
| NULL | -0.10033467208545055 | -0.10033467208545055 | -0.6483608274590866 |
| -1.5574077246549023 | NULL | -33.71948732190433 | -6.405331196646276 |
| 1.1578212823495775 | 1.2345994590490046 | NULL | 6.405331196646276 |
| 0.27190061199763077 | -1.5574077246549023 | -1.5574077246549023 | -0.27190061199763077 |
| -0.29100619138474915 | 14.101419947171719 | 14.101419947171719 | 0.27190061199763077 |
| -1.2219599181369434 | -2.706013866772691 | -2.706013866772691 | NULL |
| 1.5574077246549023 | -0.979852083895097 | -0.979852083895097 | -1.5574077246549023 |
| 1.995200412208242 | -0.6291704256385503 | -0.6291704256385503 | 0.0 |
| 0.6483608274590866 | 0.5246662219468002 | 0.5246662219468002 | 1.995200412208242 |
+----------------------+----------------------+----------------------+----------------------+Related functions
TAN function is a mathematical function. For more information about functions for data calculation and data conversion, see Mathematical functions.