Data Conversion Functions

TIBCO Cloud™ Integration - Connect provides a set of data conversion functions that allow you to change the data type of a field as part of an integration. If the data type cannot be converted, an error is returned.

The data conversion functions are:

The conversion rules are described in the following table. Columns are function names, rows are data types.

	TOBOOLEAN	TODATETIME	TODECIMAL	TODOUBLE	TOHEX	FROMHEX	TOINTEGER	TOSTRING
Boolean data	n/a	Error	Converts a Boolean value to the equivalent decimal number.	Converts a Boolean value to the equivalent double-precision number	Error	Error	Converts a Boolean value to the equivalent 32-bit signed integer	Converts a Boolean value to its equivalent string representation.
Byte data	Converts an 8-bit unsigned integer to an equivalent Boolean value.	Error	Converts an 8-bit unsigned integer to the equivalent decimal number.	Converts an 8-bit unsigned integer to the equivalent double-precision number.	Converts an 8-bit unsigned integer to its equivalent hexadecimal string representation.	Error	Converts an 8-bit unsigned integer to the equivalent 32-bit signed integer.	Converts an 8-bit unsigned integer to its equivalent string representation.
DateTime data	Error	n/a	Error	Error	Error	Error	Error	Converts a DateTime value to its equivalent string representation.
Decimal data	Converts decimal data to an equivalent Boolean value.	Error	n/a	Converts a decimal number to an equivalent double-precision number.	Error	Error	Converts a decimal number to an equivalent 32-bit signed integer.	Converts a decimal number to its equivalent string representation.
Double data (any)	Converts a double-precision number to an equivalent Boolean value.	Error	Converts a double-precision number to an equivalent decimal number.	n/a	Error	Error	Converts a double-precision number to an equivalent 32-bit signed integer.	Converts a double-precision number to its equivalent string representation.
Integer data (any)	Converts signed integer data to an equivalent Boolean value.	Error	Converts signed integer data to an equivalent decimal number.	Converts signed integer data to an equivalent double-precision number.	Converts signed integer data to its equivalent hexadecimal string representation.	Error	n/a	Converts signed integer data to its equivalent string representation.
Hexadecimal data	Error	Error	Error	Error	n/a	Converts a hexadecimal string to its Int64 representation.	Error	Error
String data	Converts the string to an equivalent Boolean value.	Converts the string representation of a date and time to an equivalent DateTime value.	Converts the string representation of a number to an equivalent decimal number.	Converts the string representation of a number to an equivalent double-precision number.	Converts the string representation of an integer to an equivalent hexadecimal string.	Error	Converts the string representation of a number to an equivalent 32-bit signed integer.	n/a
String (1) data	Error	Error	Error	Error	Error	Error	Converts the specified Unicode character to the equivalent 32-bit signed integer.	Converts the specified Unicode character to its equivalent string representation.
Unsigned integer data (any)	Converts an unsigned integer to an equivalent Boolean value.	Error	Converts an unsigned integer to an equivalent decimal number.	Converts an unsigned integer to an equivalent double-precision number.	Converts an unsigned integer to an equivalent hexadecimal string representation.	Error	Converts an unsigned integer to an equivalent 32-bit signed integer.	Converts an unsigned integer to an equivalent string representation.

Data Conversion Functions

Related Topics