TANH

All functions > MATH > TANH

Returns the hyperbolic tangent of a number.

Signatures

Returns: Hyperbolic tangent result (between -1 and 1)

TANH(number: T) → DOUBLE
sql
ParameterTypeRequiredDescription
numberTYesAny real number (DOUBLE)

Notes

  • Definition: TANH(x) = SINH(x) / COSH(x) = (e^x - e^(-x)) / (e^x + e^(-x))
  • Returns values in the range (-1, 1)
  • TANH(0) = 0
  • Odd function: TANH(-x) = -TANH(x)
  • Approaches 1 as x approaches infinity
  • Approaches -1 as x approaches negative infinity
  • S-shaped (sigmoid) function
  • Returns NULL if input is NULL

Examples

FeatureQL
SELECT
    f1 := TANH(0e0),  -- Hyperbolic tangent of 0 is 0
    f2 := TANH(1e0),  -- Hyperbolic tangent of 1
    f3 := TANH(-1e0),  -- Odd function: TANH(-1) = -TANH(1)
    f4 := TANH(2e0),  -- Hyperbolic tangent of 2
    f5 := TANH(5e0)  -- Approaches 1 for large positive values
;
Result
f1 VARCHARf2 VARCHARf3 VARCHARf4 VARCHARf5 VARCHAR
0.00.7615941559557649-0.76159415595576490.96402758007581690.9999092042625951

Last update at: 2026/03/03 16:47:38
Last updated: 2026-03-03 16:48:19