Skip to main content

cot

1. COT Function​

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