TANH()

All functions > MATH > TANH()

Returns the hyperbolic tangent of a number.

Signatures

Hyperbolic tangent

Returns: Hyperbolic tangent, in (-1, 1)

TANH(number: T) → DOUBLE

With:

• T : Floating-point type (FLOAT, DOUBLE)

Signature notes:

• Definition: TANH(x) = SINH(x) / COSH(x)
• Returns values in (-1, 1)
• Odd function: TANH(-x) = -TANH(x)
• Approaches ±1 as x approaches ±∞
• Returns NULL if the input is NULL

Examples

SELECT
    f1 := TANH(0E0), -- tanh(0) = 0
    f2 := TANH(1E0), -- tanh(1)
    f3 := TANH(-1E0), -- Odd function
    f4 := TANH(5E0) -- Approaches 1 for large x
;