Working with Date fields

In order to load data into date or time fields date format must be provided for the source field. Our ETL Software automatically converts data into the format required for the target database.

Performance tips

  • Applying date/time format is a very processor-intensive operation,
  • Shorter formats are faster,
  • Formats with no months names are faster as well,
  • dd/mm/yyyy is faster than d/m/yy.
Import Date Formats
  • Various formats can be selected using drop-down box
  • If the format is missing it can be entered

Important thing is to understand that this format has nothing to do with your target database. This is the format of the source data. It is there to help to convert a string into date-time type inside of the software, so it can be loaded later into the date or timestamp field

Video Tutorial

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum
Last updated: October 22, 2022