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

cot

1. COT Function

======= cot | H2 Function | SQLDoc

cot

1. COT Function

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The COT function in H2 database is used to calculate the cotangent of a given angle in radians.

2. Syntax

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

COT(angle)

Arguments

  • angle: The angle for which the cotangent needs to be calculated. It should be a numeric value representing the angle in radians.

Return

  • The COT function returns the cotangent of the given angle.

3. Notes

  • The COT function in H2 database expects the angle to be in radians. If the angle is in degrees, you can convert it to radians using the RADIANS function.
  • If the input angle is not a number or exceeds the numeric range, the COT function will return NULL.
  • Take care to use the correct syntax and datatype while using the COT function to avoid errors.

4. Examples

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

Example 1 - Calculating the cotangent of 1 radian:

SELECT COT(1) AS cotangent;

Output:

cotangent
---------
0.642092615934331

Example 2 - Calculating the cotangent of an angle stored in a column:

CREATE TABLE angles (
id INT PRIMARY KEY,
angle DOUBLE
);

INSERT INTO angles VALUES (1, 0.5), (2, 1), (3, 1.5);

SELECT id, angle, COT(angle) AS cotangent
FROM angles;

Output:

id | angle |       cotangent
---+-------+---------------------
1 | 0.5 | 1.8304877217124522
2 | 1 | 0.642092615934331
3 | 1.5 | 0.13352640702141594
  • tan - Calculate tangent
  • sin - Calculate sine
  • cos - Calculate cosine