Advanced-etl-processor
Working with Date/Time fields
In order to load data into target database’s Date or Time fields, it should be converted into YYYY-MM-DD HH:NN:SS.FFF format. This transformation is done by “Date format” transformation function.
- It is possible to apply multiple date formats.
- The first format which works is used.
- If the data is already in the required
YYYY-MM-DD HH:NN:SS.FFFformat, no conversion is needed. - Watch out for leading and trailing spaces, as they may affect transformation accuracy.
- When loading data into a Time field, the Date portion is ignored.
For more technologies supported by our ETL Software see Advanced ETL Processor Versions
Confused? Ask question on our ETL Forum