The format of the TO_DATE string must match the format string including any date separators. If it does not,
Data Integration
might return inaccurate values or skip the row. For example, if you pass the string ‘20200512’, representing May 12, 2020, to TO_DATE, you must include the format string YYYYMMDD. If you do not include a format string,
Data Integration
expects the string in the default date format MM/DD/YYYY HH24:MI:SS. Likewise, if you pass a string that does not match the format string,
Data Integration
returns an error and skips the row. For example, if you pass the string 2020120 to TO_DATE and include the format string YYYYMMDD,
Data Integration
returns an error and skips the row because the string does not match the format string.