Table of Contents

Search

  1. About the Data Vault SQL Reference
  2. Introduction to SQL Reference for Informatica Data Vault
  3. Date and Time Arithmetic
  4. WHERE Clauses
  5. UNION Operator
  6. Parameterized Query
  7. Functions

Data Vault SQL Reference

Data Vault SQL Reference

LOG10

LOG10

A math function that returns the base 10 logarithm of the input expression. If the input expression evaluates to a negative number or 0, an error message is returned.

LOG10 Syntax

LOG10 (double)

LOG10 Example

Input
Output
2
3.01029995663981e-01
CREATE TABLE num_table (col1 SMALLINT); INSERT INTO num_table VALUES (2); 1 row affected SELECT LOG10(col1) FROM num_table; 1 row selected 1 ---------------------- 3.01029995663981e-01

0 COMMENTS

We’d like to hear from you!