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

POWER

POWER

A math function that returns a value that is calculated as
value-expression1
raised to the power of
value-expression2
. If both input values are integers, then the result is INTEGER; otherwise the result is a FLOAT value.

POWER Syntax

POWER (double value-expression1, double value-expression2) POW (double value-expression1, double value-expression2)

POWER Examples

Input
Output
4, 8
65536
4.0, 8
6.55360000000000e+04
4, 0.5
2.00000000000000e+00
4, -2.0
6.25000000000000e-02
CREATE TABLE num_table (col1 SMALLINT, col2 SMALLINT); INSERT INTO num_table VALUES (4, 8); 1 row affected SELECT POWER(col1, col2) FROM num_table; 1 row selected 1 ----------- 65536 SELECT POWER(4.0, col2) FROM num_table; 1 row selected 1 ---------------------- 6.55360000000000e+04 SELECT POWER(col1, 0.5) FROM num_table; 1 row selected 1 ---------------------- 2.00000000000000e+00 SELECT POWER(col1, -2.0) FROM num_table; 1 row selected 1 ---------------------- 6.25000000000000e-02

0 COMMENTS

We’d like to hear from you!