PowerCenter
All Products
Function | Amazon Redshift
| IBM DB2 | Microsoft SQL Server | Netezza | Oracle | SAP HANA | Sybase ASE | Teradata | Vertica
|
---|---|---|---|---|---|---|---|---|---|
ABORT()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
ABS()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
ADD_TO_DATE()
| X
| X
| S
| X
| X
| X
| S
| X
| X
|
AES_DECRYPT()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
AES_ENCRYPT()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
ASCII()
| X
| X
| X
| X
| X
| X
| X
| -
| X
|
AVG()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
CEIL()
| -
| X
| X
| X
| X
| -
| X
| S
| S
|
CHOOSE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
CHR()
| -
| X
| X
| X
| X
| -
| X
| -
| X
|
CHRCODE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
COMPRESS()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
CONCAT()
| X
| S
| S
| -
| X
| X
| S
| S
| X
|
COS()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
COSH()
| -
| X
| S
| X
| X
| -
| S
| X
| X
|
COUNT()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
CRC32()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
CUME()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
DATE_COMPARE()
| -
| S
| S
| X
| S
| -
| S
| S
| X
|
DATE_DIFF()
| -
| -
| -
| -
| -
| -
| -
| -
| X
|
DECODE()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
DECODE_BASE64()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
DECOMPRESS()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
ENCODE_BASE64()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
EXP()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
FIRST()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
FLOOR()
| -
| X
| X
| X
| X
| -
| X
| S
| X
|
FV()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
GET_DATE_PART()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
GREATEST()
| -
| -
| -
| -
| X
| -
| -
| -
| -
|
IIF()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
IN()
| -
| X
| X
| -
| X
| -
| X
| X
| -
|
INDEXOF()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
INITCAP()
| -
| -
| -
| -
| X
| -
| -
| -
| X
|
INSTR()
| -
| S
| X
| -
| X
| -
| S
| S
| X
|
IS_DATE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
IS_NUMBER()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
IS_SPACES()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
ISNULL()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
LAST()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
LAST_DAY()
| -
| -
| -
| -
| X
| -
| -
| -
| X
|
LEAST()
| -
| -
| -
| -
| X
| -
| -
| -
| -
|
LENGTH()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
LN()
| -
| -
| -
| X
| -
| -
| -
| -
| X
|
LOG()
| -
| X
| S
| X
| X
| -
| S
| S
| S
|
LOOKUP
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
LOWER()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
LPAD()
| -
| -
| -
| X
| X
| -
| -
| -
| X
|
LTRIM()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
MAKE_DATE_TIME()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
MAX()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
MD5()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
MEDIAN()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
METAPHONE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
MIN()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
MOD()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
MOVINGAVG()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
MOVINGSUM()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
NPER()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
PERCENTILE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
PMT()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
POWER()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
PV()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
RAND()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
RATE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REG_EXTRACT()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REG_MATCH()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REG_REPLACE
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REPLACECHR()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REPLACESTR()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
REVERSE()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
ROUND(DATE)
| -
| -
| -
| -
| X
| -
| -
| -
| S
|
ROUND(NUMBER)
| -
| X
| X
| X
| X
| -
| X
| S
| S
|
RPAD()
| -
| -
| -
| X
| X
| -
| -
| -
| X
|
RTRIM()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
SET_DATE_PART()
| -
| -
| -
| -
| -
| -
| -
| -
| -
|
SIGN()
| -
| X
| X
| X
| X
| -
| X
| S
| S
|
SIN()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
SINH()
| -
| X
| S
| X
| X
| -
| S
| X
| X
|
SOUNDEX()
| -
| X
| X
| -
| X
| -
| X
| -
| X
|
SQRT()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
STDDEV()
| -
| X
| X
| -
| X
| -
| -
| X
| X
|
SUBSTR()
| X
| S
| S
| X
| X
| X
| S
| S
| X
|
SUM()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
SYSDATE()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
SYSTIMESTAMP()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
TAN()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
TANH()
| -
| X
| S
| X
| X
| -
| S
| X
| X
|
TO_BIGINT
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
TO_CHAR(DATE)
| X
| X
| X
| X
| X
| X
| X
| S
| X
|
TO_CHAR(NUMBER)
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
TO_DATE()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
TO_DECIMAL()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
TO_FLOAT()
| -
| X
| X
| X
| X
| -
| X
| X
| X
|
TO_INTEGER()
| -
| X
| S
| X
| X
| -
| S
| X
| X
|
TRUNC(DATE)
| -
| -
| -
| X
| X
| -
| -
| -
| S
|
TRUNC(NUMBER)
| -
| X
| X
| X
| X
| -
| S
| S
| S
|
UPPER()
| X
| X
| X
| X
| X
| X
| X
| X
| X
|
VARIANCE()
| X
| X
| X
| -
| X
| X
| -
| X
| X
|
Updated July 04, 2018