Versions Compared

Key

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

...

PARSE-AS-DATETIME is more restrictive than PARSE-AS-SIMPLEDATE. The date and time patterns for PARSE-AS-DATETIME must exactly match the input strings. For example, if you use the PARSE-AS-SIMPLEDATE directive with this input string 1/2/09 6:17, you can enter MM/dd/yy HH:mm as the format pattern and the Wrangler transforms the value to 2009-01-02T06:17Z[UTC]. However, if you use PARSE-AS-DATETIME on the same input string, 1/2/09 6:17 and enter MM/dd/yy HH:mm as the pattern, an the following error occurs.:

...

This is because the input string doesn’t exactly match the format string. The correct format string in this case is M/D/yy H:mm.

...