Function Overview
A breakdown of the functions available in TARGIT InMemory Database SQL dialect.
- LTRIM (string)
- MAX (number1, number2)
- MAXLIST (val1, val2… valn)
- MIN (number1, number2)
- MINLIST (param1, param2, param3 ,.. paramn)
- MONTH (date)
- MONTHNAME (date)
- OPENBAL (measure, [DateColumnName])
- OPENBALWITHZEROES (measure, [DateColumnName])
- POW (number, power)
- RAND()
- REMOVE (string, start_pos)
- REPLACE (string1, string2, string3)
- REVERSE (string)
- RIGHT (string, number)
- ROUND (number, decimal_places)
- RTRIM (string)
- SAFECAST (expression)
- SIGN (number)
- SIN (number)
- SINH (number)
- SLEEP
- SQRT (number)
- STARTSWITH (string, substring)
- STDEV | STDDEV (numeric fieldname)
- STDEV_P | STDDEV_P (numeric fieldname)
- String Functions
- SUBSTRING (string, start_pos, [NoOfChars])
- SUM (expression)
- TAN (number)