Data Types and Type Conversion

Data Types

The following table lists the data types used in new data integration runtime and its expression engine.

Data type Description
bool A boolean value. Can be true or false.
bytes An array of bytes, containing binary data. Can have variable length.
datetime A value, representing a moment in time, that consists of year, month, day, hour, minute, seconds, and fractional seconds. Datetime values have fixed scale for fractional seconds of
datetimeoffset A value, representing a moment in time. In addition to year, month, day, hour, minute, seconds, and fractional seconds, datetimeoffset also includes a time zone offset - the number of hours and minutes that the time is offset from the Coordinated Universal Time (UTC).
decimal An exact numeric value that has a fixed precision of 29 and a scale from 0 to 28.
float4 Single precision (4 bytes) floating point values.
float8 Double precision (8 bytes) floating point values.
guid Guid (globally unique identifier) values.
int1 Signed 1-byte integer value. Can have values from -128 to 127.
int2 Signed 2-byte integer value. Can have values from -32768 to 32767.
int4 Signed 4-byte integer value. Can have values from -2,147,483,648 to 2,147,483,647.
int8 Signed 8-byte integer value. Can have values from -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807.
string A null-terminated Unicode character string value. Can have variable length. Maximal length is
time A time value, consisting of hours, minutes, and seconds.

Data Type Conversion

For data type conversion, use data type conversion functions with one argument - the value to convert.

As for datetime conversion to string and vice versa - it is performed according to the culture settings of locale, specified for the imported CSV files. If the import package imports data from a database or cloud app, the invariant culture is used.