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 loads data from a database or cloud app, the invariant culture is used.