Function Overview
A breakdown of the functions available in TARGIT InMemory Database SQL dialect.
- COSH (number)
- COUNT
- CSTR (expression)
- DATE ( )
- DATEADD (intervalstring, integer, date)
- DATEDIFF (intervalstring, date1, date2)
- DATEDIFFMILLISECONDS (end_date, start_date)
- DATEDIFFTICK (end_date, start_date)
- DATEPART (datepart, date)
- DATESERIAL (yearint, monthint, dayint)
- DAY (date)
- DAYOFWEEK (date)
- ENDSWITH (string, substring)
- FLOOR (number)
- FORMAT (date|number, format_string)
- Functions that are available in tiImport Expressions
- GETDATE ( )
- GETUTCDATE ( )
- IIF (condition, valueifTrue, valueifFsalse)
- INSERT (base_string, startPos, strtoInsert)
- ISNULL (value, alternateValue)
- ISNULLOREMPTY(column)
- LASTCHILD
- LASTPRICE
- LASTPRICEWITHZEROES
- LCASE (string)
- LEFT (string, number)
- LEN (string)
- LOG (number)
- LOG (number, base)