Date Format

In order to load data into Date/Time fields, it should be converted into 'yyyy-mm-dd hh:nn:ss.fff' format

KeyValue
CategoryTransformation Function
DescriptionReturns Date in ‘yyyy-mm-dd hh:nn:ss.fff' format.
Properties
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

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: 17/09/2018 09:45
  • by admin