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

atan

1. ATAN Function

======= atan | H2 Function | SQLDoc

atan

1. ATAN Function

>>>>>>> 9d19b1c8cb744c8e86d5c15b74d8b5f719ad62be

The ATAN function in H2 database is used to calculate the arctangent of a given number.

2. Syntax

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

ATAN(number)

Arguments

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

Return

  • The ATAN function returns the arctangent of the given number in radians.

3. Notes

  • The ATAN function in H2 database calculates the arctangent of a number and returns the result in radians.
  • The input number should be a numeric value. If the number is not a valid numeric value, the ATAN function will return NULL.
  • Make sure to use the correct syntax and datatype while using the ATAN function to avoid errors.

4. Examples

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

Example 1 - Calculating the arctangent of a number:

SELECT ATAN(0.5) AS arctangent;

Output:

arctangent
----------
0.4636476090008061

Example 2 - Calculating the arctangent of numbers stored in a column:

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

INSERT INTO numbers VALUES (1, 0.2), (2, 0.5), (3, 1);

SELECT id, value, ATAN(value) AS arctangent
FROM numbers;

Output:

id | value |      arctangent
---+-------+------------------
1 | 0.2 | 0.1973955598498808
2 | 0.5 | 0.4636476090008061
3 | 1 | 0.7853981633974483
  • tan - Calculate tangent
  • atan2 - Calculate arctangent of two numbers