Data Types and Type Conversion
The following table lists the data types used in new data integration runtime and its expression engine.
|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.