Functions | Amazon Redshift | DB2 | Google BigQuery | Microsoft Azure SQL Data Warehouse | Netezza | PostgreSQL | Snowflake | Teradata |
|---|---|---|---|---|---|---|---|---|
ABS() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
ADD_TO_DATE() | Source, Full | Full | Source, Full | Source, Full | - | - | Source, Full | Full |
ASCII() | - | Full | - | Source, Full | - | Source, Full | Source, Full | - |
AVG() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
CEIL() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
CHR() | Source, Full | Full | - | Source, Full | - | Source, Full | Source, Full | - |
CONCAT() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
COS() | Source, Full | Full | Source, Full | Source, Full | Source, Full | - | Source, Full | Source, Full |
COSH() | - | Full | - | - | - | - | Source, Full | Full |
COUNT() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
DATE_COMPARE() | Source, Full | Full | Source, Full | - | Source, Full | - | Source, Full | Source, Full |
DATE_DIFF() | Source, Full | - | - | Source, Full | - | - | Source, Full | - |
DECODE() | Source, Full | Full | - | Source, Full | Source, Full | - | Source, Full | Source, Full |
EXP() | Source, Full | Full | - | Source, Full | Source, Full | - | Source, Full | Source, Full |
FIRST() | - | - | - | Source, Full | - | - | - | - |
FLOOR() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
GET_DATE_PART() | Source, Full | Full | Source, Full | Source, Full | - | - | Source, Full | Full |
IIF() | Source, Full | Full | - | Source, Full | Source, Full | - | Source, Full | Source, Full |
IN() | Source, Full | Full | - | - | Source, Full | - | - | Source, Full |
INITCAP() | Source, Full | Full | - | - | - | - | Source, Full | - |
INSTR() | Source, Full | Full | Source, Full | Source, Full | - | - | Source, Full | Full |
ISNULL() | Source, Full | Full | Source, Full | Source, Full | Source, Full | - | Source, Full | Source, Full |
LAST() | - | - | - | Source, Full | - | - | - | - |
LAST_DAY() | Source, Full | Full | Source, Full | - | - | - | Source, Full | - |
LENGTH() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
LN() | Source, Full | - | - | - | - | - | Source, Full | Full |
LOG() | - | Full | - | Source, Full | - | - | Source, Full | Full |
LOWER() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
LPAD() | Source, Full | Full | - | - | - | Source, Full | Source, Full | - |
LTRIM() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
MAKE_DATE_TIME() | - | - | - | Source, Full | - | - | - | - |
MAX() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
MAX(NUMBER,DATE,STRING) | - | - | - | - | - | - | - | - |
MIN(NUMBER,DATE,STRING) | - | - | - | - | - | - | - | - |
MEDIAN() | - | - | - | - | - | - | Source, Full | - |
MIN() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
MD5() | Source, Full | - | - | Source, Full | - | - | Source, Full | - |
MOD() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
POWER() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
REPLACECHR() | - | - | Source, Full | Source, Full | - | - | - | - |
REPLACESTR() | - | - | Source, Full | Source, Full | - | - | Source, Full | - |
ROUND(NUMBER) | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
RPAD() | Source, Full | Full | - | - | - | Source, Full | Source, Full | - |
RTRIM() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
SET_DATE_PART() | - | - | - | Source, Full | - | - | - | - |
SIGN() | Source, Full | Full | - | Source, Full | - | - | Source, Full | Full |
SIN() | Source, Full | Full | Source, Full | Source, Full | Source, Full | - | Source, Full | Source, Full |
SINH() | - | Full | - | Source, Full | - | - | Source, Full | - |
SOUNDEX() | - | Full | - | Source, Full | - | - | - | - |
SQRT() | Source, Full | Full | Source, Full | Source, Full | Source, Full | - | Source, Full | Source, Full |
STDDEV() | Source, Full | Full | - | Source, Full | - | - | Source, Full | Full |
SUBSTR() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
SUM() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
SYSTIMESTAMP() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | - | Full |
TAN() | Source, Full | Full | Source, Full | Source, Full | Source, Full | - | Source, Full | Source, Full |
TANH() | - | Full | - | Source, Full | - | - | Source, Full | Full |
TO_BIGINT | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
TO_CHAR(DATE) | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | - | Full |
TO_CHAR(NUMBER) | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
TO_DATE() | Source, Full | Full | Source, Full | Source, Full | - | Source, Full | Source, Full | Full |
TO_DECIMAL() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Full |
TO_FLOAT() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Full |
TO_INTEGER() | Source, Full | Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Full |
TO_NUMBER() | - | - | - | - | - | - | Source, Full | - |
TRUNC(DATE) | Source, Full | - | Source, Full | - | - | - | Source, Full | - |
TRUNC(NUMBER) | Source, Full | Full | Source, Full | Source, Full | - | - | Source, Full | Full |
UPPER() | Source, Full | - | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full | Source, Full |
VARIANCE() | Source, Full | - | - | Source, Full | - | - | Source, Full | Full |