Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
Data types and expressionsThese topics describe the data types and expressions that HCL OneDB™supports.
Expression
Function Expressions
Exponential and Logarithmic Functions Exponential and logarithmic functions take at least one argument and return a FLOAT data type.
LOGN FunctionThe LOGN function returns the natural logarithm of a numeric argument.

LOGN Function

The LOGN function returns the natural logarithm of a numeric argument.

This return value is the inverse of the exponential value that the EXP function returns from the same argument.

The following query returns the natural log of population for each row of the history table:

SELECT LOGN(population) FROM history WHERE country='US'
   ORDER BY date;