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 […]

TypeNameOf The TypeNameOf function returns the xSQL data type for the given input parameter. Syntax TypeNameOf(<value or expression>) Return Type String Details TypeNameOf is a helper function that returns the […]

IsNumberFormat The IsNumberFormat function evaluates if the given input parameter conforms to the specified numeric formatting mask. Syntax IsNumberFormat(<expression or string>, <format>) The first parameter can be a value or […]

IsIntegral The IsIntegral function validates if the input parameter is a whole number. Syntax IsIntegral(<expression or value>) Return Type Boolean Details n/a Examples eval IsIntegral(100.1); eval IsIntegral(42); select if IsIntegral(amount) […]