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.

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.

  • Various formats can be selected using drop-down box
  • If the format is missing it can be entered

The full list of date formats can be found here: Date formats

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

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/import/working_with_date_fields.txt
  • Last modified: 15/05/2018 08:20
  • by admin