Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • Inputs can be of any type. 
  • If the input is not a Datetime value and does match one of the specified formats, the output is in the following format: yyyy-MM-dd HH:mm:ss.
  • If the input is a Datetime value and does match, the output is in the input's Datetime format.
Info

NOTE: Parsing of dates may depend on how dates are recognized by the running environment where the transformation is executed. In some cases, locale settings for the backend running environment may be different from your user locale settings, which affect how values are interpreted in the Transformer page. If you are having difficulties with execution of the PARSEDATE function, you can try to set your locale settings to U.S. to fix your recipes. This is a known issue. 

After you have converted your strings values to dates, if a sufficient percentage of input strings from a column are successfully converted to one of the matching formats, the column may be retyped as Datetime.

...