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.
If your data is already in standard ODBC format YYYY-MM-DD HH:NN:SS.FFF there is no need to apply the format

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

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