Date Format
In order to load data into Date/Time fields, it should be converted into 'YYYY-MM-DD HH:NN:SS.FFF' format
| Key | Value |
|---|---|
| Category | Transformation Function |
| Description | Returns Date in ‘YYYY-MM-DD HH:NN:SS.FFF' format. |
| Properties |
It is possible to apply multiple data formats The first format which works is used if the data is already in YYYY-MM-DD HH:NN:SS.FFF format there is no need to convert it
To change Transformation function properties double-click on it
For more technologies supported by our ETL Software see Advanced ETL Processor Versions and Visual Importer ETL Versions
Confused? Ask question on our ETL forum