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.

 

Related Topics

TIBCO Cloud™ Integration - Connect Functions

Formula Editor Operators

Formula Editor Overview