Date Format

In order to load data into Date/Time fields, it should be converted into 'YYYY-MM-DD HH:NN:SS.FFF' format

CategoryTransformation Function
DescriptionReturns Date in ‘YYYY-MM-DD HH:NN:SS.FFF' format.
It is possible to apply multiple data 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

To change Transformation function properties double-click on it

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/transformation_functions/date/date_format.txt
  • Last modified: 02/03/2023 11:16
  • by admin