Data Integration Connectors
- Data Integration Connectors
- All Products
ASK INFAPreview
Please log in to access Ask INFA.
ASK INFAPreview
Function
| Function
|
|---|---|
ABS()
| MIN() |
ADD_TO_DATE()
| MOD() |
ASCII()
| POWER() |
AVG()
| RAND() |
CEIL()
| REG_EXTRACT() |
CHR()
| REG_MATCH() |
CONCAT()
| REG_REPLACE() |
COS()
| REPLACESTR() |
COSH()
| REPLACECHR() |
COUNT()
| REVERSE() |
CRC32()
| ROUND(DATE) |
DATE_COMPARE()
| ROUND(NUMBER) |
DATE_DIFF()
| RPAD() |
DECODE()
| RTRIM() |
EXP()
| SET_DATE_PART() |
FLOOR()
| SHA256() |
GET_DATE_PART()
| SIN() |
GREATEST()
| SINH() |
IIF()
| SQRT() |
IN()
| STDDEV() |
INDEXOF()
| SUBSTR() |
INITCAP()
| SUM() |
INSTR()
| SYSDATE() |
IS_DATE()
| SYSTIMESTAMP() |
IS_NULL()
| TAN() |
IS_NUMBER()
| TANH() |
IS_SPACES()
| TO_BIGINT |
LAST()
| TO_CHAR(DATE) |
LAST_DAY()
| TO_CHAR(NUMBER) |
LENGTH()
| TO_DATE() |
LN()
| TO_DECIMAL() |
LOWER()
| TO_FLOAT() |
LPAD()
| TO_INTEGER() |
LTRIM()
| TRUNC(DATE) |
MAKE_DATE_TIME()
| TRUNC(NUMBER) |
MAX()
| UPPER() |
MEDIAN() | VARIANCE() |
MD5() | -
|
