Working with date and 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 YYYY-MM-DD HH:NN:SS.FFF format, there is no need to convert it.
Be aware of leading and trailing spaces
When data is loaded into time field date part is ignored

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

  • aetle/processing_data/writer/working_with_date_and_time_fields.txt
  • Last modified: 17/09/2018 09:45
  • by admin