8.2.12 TAN

Returns the tangent (TAN trigonometric function) of the target data, which must be specified in radians.

Organization of this subsection

(1) Specification format

scalar-function-TAN ::= TAN(target-data)
 
  target-data ::= value-expression

target-data:

Specifies the numeric data whose tangent is to be determined.

The following rules apply:

Specify the target data in the form of a value expression. For details about value expressions, see 7.20 Value expression.
Specify numeric data for the target data. For details about numeric data, see (1) Numeric data in 6.2.1 List of data types.
You cannot specify a dynamic parameter by itself for the target data.

The data type of the execution result is the DOUBLE PRECISION type.
If the execution result cannot be represented in the DOUBLE PRECISION type, an overflow error is generated.
The NOT NULL constraint does not apply to the value of the execution result (the null value is allowed).
If the target data has the null value, the execution result will be a null value.

Example:

Express the value of column C1 in table T1 in radians and then determine its tangent.

SELECT TAN("C1"*PI()/180) FROM "T1"

[Figure]