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
Back to Working with Transformer
For more technologies supported by our ETL Software see
Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum
Posted on March 2, 2022
•
1 min read •
111 words