Home  /  Application Development: Core Topics  /  InterSystems SQL Reference  /  SQL Functions  /  TAN

InterSystems SQL Reference
[Back]  [Next] 
InterSystems: The power behind what matters   

A scalar numeric function that returns the tangent, in radians, of an angle.
{fn TAN(numeric-expression)}
numeric-expression A numeric expression. This is an angle expressed in radians.
TAN returns either the NUMERIC or DOUBLE data type. If numeric-expression is data type DOUBLE, TAN returns DOUBLE; otherwise, it returns NUMERIC.
TAN takes any numeric value and returns its tangent. TAN returns NULL if passed a NULL value. TAN treats nonnumeric strings as the numeric value 0.
TAN returns a value with a precision of 36 and a scale of 18.
TAN can only be used as an ODBC scalar function (with the curly brace syntax).
You can use the DEGREES function to convert radians to degrees. You can use the RADIANS function to convert degrees to radians.
The following example shows the effect of TAN.
SELECT {fn TAN(0.52)} AS Tangent 
returns 0.572561.
See Also