Below is a breakdown of the functions available in TARGIT InMemory Database SQL dialect.
String Functions
String Functions - CAST | CAST_STR_AS_INT | CAST_STR_AS_DECIMAL | CHAR | CHARINDEX | CHARINDEXSTD | COALESCE | CONCAT | CSTR | ENDSWITH | INSERT | ISNULL | ISNULLOREMPTY | LEFT | LEN | LCASE | LTRIM | REMOVE | REPLACE | REVERSE | RIGHT | RTRIM | SUBSTRING | STARTSWITH | TRIM | UCASE
Date Functions - CDATE | DATE | GETDATE | DATEADD | DATEDIFF | DATEDIFFMILLISECOND | DATEPART | DATESERIAL | DAY | DAYOFWEEK | MONTH | TRUNC | YEAR
Math - ABS | CAST_NUM_AS_BYTE | CAST_NUM_AS_DECIMAL | CAST_NUM_AS_DOUBLE | CAST_NUM_AS_INT | CAST_NUM_AS_LONG | CAST_NUM_AS_SHORT | CAST_NUM_AS_SINGLE | FLOOR | LOG | MAX | MAXLIST | MIN | MINLIST | POWER | RAND | ROUND | SIGN | SQRT
Trigonometric - ASIN | ACOS | ATAN | ATAN2 | COS | COSH | SIN | SINH | TAN | TANH
Aggregate Functions - MIN | MAX | COUNT | AVG | SUM | COUNT ( DISTINCT() ) | MINLIST | MAXLIST
Statistical Functions - Statistical Functions
STDEV| STDEVP | VAR | VARP
Functions that are available in tiImport Expressions
These functions are available in tiImport expressions only. They are a subset of the TARGIT InMemory Database SQL functions.
Functions with 1 parameters - DAY | DAYOFWEEK | MONTH | YEAR | ABS | FLOOR | INT | LEN | UCASE | LCASE | TRIM | LTRIM | RTRIM | SIGN | WEEKDAY
Functions with 2 parameters - LEFT | RIGHT | CONCAT | ENDSWITH | FORMAT
Functions with 3 parameters - DATESERIAL| DATEADD| DATEDIFF | IIF | REPLACE

  • No labels