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