Hitachi

Hitachi Advanced Database SQL Reference


8.2.11 SINH

Returns the hyperbolic sine of the target data.

Organization of this subsection

(1) Specification format

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

(2) Explanation of specification format

target-data:

Specifies the numeric data whose hyperbolic sine is to be determined.

The following rules apply:

(3) Rules

  1. The data type of the execution result is the DOUBLE PRECISION type.

  2. If the execution result cannot be represented in the DOUBLE PRECISION type, an overflow error is generated.

  3. The NOT NULL constraint does not apply to the value of the execution result (the null value is allowed).

  4. If the target data has the null value, the execution result will be a null value.

(4) Example

Example:

Determine the hyperbolic sine of the values in columns C1 to C3 in table T1.

SELECT SINH("C1"),SINH("C2"),SINH("C3") FROM "T1"

[Figure]