<<<<<<< HEAD sinh | H2 | SQLDoc
Skip to main content

sinh

1. SINH Function​

======= sinh | H2 Function | SQLDoc

sinh

1. SINH Function​

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The SINH function in H2 database is used to calculate the hyperbolic sine of a given number.

2. Syntax​

The syntax for the SINH function in H2 database is as follows:

SINH(number)

Arguments​

  • number: The number for which the hyperbolic sine needs to be calculated. It should be a numeric value.

Return​

  • The SINH function returns the hyperbolic sine of the given number.

3. Notes​

  • The SINH function in H2 database calculates the hyperbolic sine using the exponential function, where sinh(x) = (e^x - e^(-x)) / 2.
  • The input number can be positive, negative, or zero.
  • If the input number exceeds the numeric range, the SINH function will return NULL.
  • Ensure that the correct syntax and datatype are used while using the SINH function to avoid errors.

4. Examples​

Here are a few examples demonstrating the usage of the SINH function in H2 database:

Example 1 - Calculating the hyperbolic sine of a number:​

SELECT SINH(2) AS sinh_value;

Output:

sinh_value
----------
3.6268604078470186

Example 2 - Calculating the hyperbolic sine of numbers stored in a column:​

CREATE TABLE numbers (
  id INT PRIMARY KEY,
  value DOUBLE
);

INSERT INTO numbers VALUES (1, 0.5), (2, 1.2), (3, -0.8);

SELECT id, value, SINH(value) AS sinh_value
FROM numbers;

Output:

id | value |   sinh_value
---+-------+---------------
1  | 0.5   |  0.5210953055
2  | 1.2   |  1.5094613554
3  | -0.8  | -0.6640367703
  • cosh - Calculate hyperbolic cosine
  • tanh - Calculate hyperbolic tangent