Versions Compared

Key

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

...

  1. If the input format is a string
  2. If the input format is not in a standard International Organization for Standardization (ISO) format compliant

Anchor
sqlCld_120_tut_handleDates_isString
sqlCld_120_tut_handleDates_isString
Input format is a string

...

The app automatically detects the input format that is ISO standard compliant and is supported by the Moment.js library. Refer to this article to know more about the supported formatting options and this article to know more about format tokens.

Anchor
sqlCld_120_tut_handleDates_notISO
sqlCld_120_tut_handleDates_notISO
Input format is not in the standard ISO format

In this case, the app does not recognize the date format and may show the original data or a blank value for such dates. Here, you must specify the input format so that the app can understand the given date/time tokens and format the data as desired.

...

The output is then as follows:

Additional references