Date Format

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

Date Format

Key Value
Category Transformation Function
Description Returns Date in ‘yyyy-mm-dd hh:nn:ss.fff’ format.
Properties

  • 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

Date Format Properties

Back to Working with Transformer

For more technologies supported by our ETL Software see Advanced ETL Processor Versions

Confused? Ask question on our ETL Forum

Posted on March 2, 2022 • 1 min read • 111 words
www.etl-tools.com About Support Pricing Cookies Policy Term Of Use Privacy Policy License