Long Date Conversion¶
Overview¶
The Long Date Conversion operator performs long integer and date conversion.
Input and Output¶
Input: fields to be converted
Output: new fields
Parameter Description¶
Parameter | Description | Type | Mandatory | Default Value |
|---|---|---|---|---|
convert type | Types of long integer and date conversion:
| enum | Yes | long to date |
input field name | Name of input fields to be converted. Set this parameter to the names of fields generated in the previous conversion step. | string | Yes | None |
output field name | Names of output fields. | string | Yes | None |
field unit | Unit of a long integer field. According to convert type, the value is an input field or generated field. The options are second and millisecond. | enum | Yes | second |
output field type | Output field type. The options are BIGINT, DATE, TIME, and TIMESTAMP. | enum | Yes | BIGINT |
date format | Time field format, for example, yyyyMMdd HH:mm:ss. | string | No | None |
Data Processing Rule¶
If the original data includes null values, no conversion is performed.
If the number of input field columns is greater than the number of field columns actually included in the original data, all data becomes dirty data.
If a type conversion error occurs, the current data is saved as dirty data.
Example¶
Use the CSV File Input operator to generate fields A and B.
The following figure shows the source file.
Configure the Long Date Conversion operator to generate four new fields C, D, E, and F. Their types are DATE, TIME, TIMESTAMP, and BIGINT, respectively.
The following figure shows the output of the conversion.
