GatherString GatherString is an aggregate function that pivots a column of input values as a single, delimited string. The output row/column is delimited by commas by default, but can be overridden to use a […]

IsRegexMatch The IsRegexMatch function uses Java regular expressions to search a string. The function returns ‘true’ if a match is found, otherwise it returns ‘false’. Syntax IsRegexMatch(<string>, <regex>) Return Type […]

Locate Use the Locate function to identify the starting position of a given substring within a string. Syntax Locate(<string_pattern>, <string_to_search> [, <integer>]) The optional integer input parameter indicates the position […]

ToInstant The ToInstant function casts date, date_time, offset_date_time, and zoned_date_time input parameters to the the instant data type. Instant stores time values as UTC Zulu time. Syntax ToInstant(date|date_time|offset_date_time|zoned_date_time) Return Type […]

ToZonedDateTime The ToZonedDateTime function converts the input string, date, or date_time to the zoned_date_time data type. The zoned_date_time data type allows the use of UTC timezone offset and zone id information with time values and is […]

ToOffsetDateTime The ToOffsetDateTime function converts the input string, date, or date_time to the offset_date_time data type. The offset_date_time data type allows the use of UTC timezone offset information with time […]

ToDateTime The ToDateTime function converts a string, date, or date time value to a date_time. Syntax ToDateTime(<String>|<date>|<offset_date_time>|<zoned_date_time>|<instant> [,<date_time_mask>]) Return Type date_time Details Connect displays dates using the ISO 8601 date […]

ToDecimal The ToDecimal function converts the input parameter to the decimal data type. Syntax ToDecimal(<any numeric type>|<string>, [[precision], [scale]]) Return Type Decimal Details Precision represents the total number of digits […]

AllTypes The AllTypes table function returns a fixed 10 row result set containing data examples for the various data types supported in xSQL. AllTypes is a utility function available for […]

TypeOf The TypeOf function returns the xSQL data type id for the given input parameter. Syntax TypeOf(<value or expression>) Return Type Integer Details The TypeOf function is mostly for internal […]