...
- If the input format is a string
- If the input format is not in a standard International Organization for Standardization (ISO) format compliant
AnchorsqlCld_120_tut_handleDates_isString sqlCld_120_tut_handleDates_isString
Input format is a string
sqlCld_120_tut_handleDates_isString | |
sqlCld_120_tut_handleDates_isString |
...
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
sqlCld_120_tut_handleDates_notISO | |
sqlCld_120_tut_handleDates_notISO |
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: