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, fractional seconds, and timezone. Datetime values have fixed scale for fractional seconds of 7 digits.
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.