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

degrees

1. DEGREES Function​

======= degrees | H2 Function | SQLDoc

degrees

1. DEGREES Function​

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The DEGREES function in H2 database is used to convert an angle from radians to degrees.

2. Syntax​

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

DEGREES(angle)

Arguments​

  • angle: The angle to be converted from radians to degrees. It should be a numeric value representing the angle in radians.

Return​

  • The DEGREES function returns the angle converted from radians to degrees.

3. Notes​

  • The DEGREES function in H2 database expects the input angle to be in radians. If the angle is already in degrees, using DEGREES function will have no effect.
  • If the input angle is not a number or exceeds the numeric range, the DEGREES function will return NULL.
  • It is important to ensure the correct syntax and data type while using the DEGREES function to avoid errors.

4. Examples​

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

Example 1 - Converting an angle from radians to degrees:​

SELECT DEGREES(1.5708) AS angle_degrees;

Output:

angle_degrees
-------------
90.0000

Example 2 - Converting angles stored in a column from radians to degrees:​

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

INSERT INTO angles VALUES (1, 0.7854), (2, 1.5708), (3, 2.3562);

SELECT id, angle_radians, DEGREES(angle_radians) AS angle_degrees
FROM angles;

Output:

id | angle_radians | angle_degrees
---+---------------+--------------
1  | 0.7854        | 45.0000
2  | 1.5708        | 90.0000
3  | 2.3562        | 135.0000
  • radians - Convert an angle from degrees to radians
  • sin - Calculate sine
  • cos - Calculate cosine