Skip to main content
Logo
visit targit.com Sign in
  1. TARGIT Community
  2. Documentation
  3. Data Warehouse Developer
  4. InMemory
  5. Function Overview

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)
  • Next ›
  • Last »

© 2022 TARGIT. All Rights Reserved. Personal Data Policy