Function Overview
A breakdown of the functions available in TARGIT InMemory Database SQL dialect.
- ABS (number)
- ACOS (number)
- ASCII (char)
- ASIN (number)
- ATAN (number)
- ATAN2 (number1, number2)
- AVG (expression)
- CAST (expression)
- CAST_NUM_AS_BYTE (number)
- CAST_NUM_AS_DECIMAL (number)
- CAST_NUM_AS_DOUBLE (number)
- CAST_NUM_AS_INT (number)
- CAST_NUM_AS_LONG (number)
- CAST_NUM_AS_SHORT (number)
- CAST_NUM_AS_SINGLE (number)
- CAST_STR_AS_DECIMAL (string)
- CAST_STR_AS_DOUBLE (string)
- CAST_STR_AS_INT (string)
- CAST_STR_AS_LONG (string)
- CDATE (string)
- CEILING (number)
- CHAR (number)
- CHARINDEX
- CHARINDEXSTD
- CLOSEBAL (measure, [DateColumnName])
- CLOSEBALWITHZEROES (measure, [DateColumnName])
- COALESCE (VAL1, VAL2… VALN)
- COLUMNEXISTS
- CONCAT (exp1, exp2… expN)
- COS (number)