Supported Data Types
This section provides information on supported data types in Designer CloudLive Query.
Designer CloudLive Query supports the following data types.
Tip
Transforms that include functions work only if the inputs are of a data type and format valid for the function. You should clean up the type and format of your columns before you apply transformations to them.
Supported Data Types
String Data Type | Any non-null value can be typed as String. A String can be anything. |
Integer Data Type | The Integer data type applies to positive and negative numeric values that have no decimal point. |
Float Data Type | A standard single-precision floating-point value. It uses 4 bytes, and can represent values from +/- 3.4 x 10-38 to 3.4 x 1038 with 7 digits of precision. A float uses a decimal that can be placed in any position and is mainly used to save memory in large arrays of floating-point numbers. |
Boolean Data Type | The Boolean data type expresses true or false values. |
Date Data Type | A 10-character String in "yyyy-mm-dd" format. |
Datetime Data Type | Default is a 19-character String in "yyyy-mm-dd HH:MM:SS" format. |
Item | Description |
|---|