Skip to main content

log

1. LOG Function​

The LOG function in H2 database is used to calculate the natural logarithm of a given number.

2. Syntax​

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

LOG(number)

Arguments​

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

Return​

  • The LOG function returns the natural logarithm of the given number.

3. Notes​

  • The LOG function in H2 database calculates the natural logarithm, which is the logarithm to the base e (Euler's number).
  • If the input number is not a positive numeric value or exceeds the numeric range, the LOG function will return NULL.
  • Ensure that the input number is appropriate and within the valid range to avoid errors.

4. Examples​

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

Example 1 - Calculating the natural logarithm of 2:​

SELECT LOG(2) AS natural_log;

Output:

natural_log
-----------
0.6931471805599453

Example 2 - Calculating the natural logarithm of numbers stored in a column:​

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

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

SELECT id, value, LOG(value) AS natural_log
FROM numbers;

Output:

id | value |    natural_log
---+-------+-----------------
1  | 1     | 0.0
2  | 2     | 0.6931471805599453
3  | 3     | 1.0986122886681098
  • ln - Calculate the natural logarithm (same as LOG)
  • log10 - Calculate the logarithm to the base 10