Investigation checklist Record the column type, input value type, session NLS settings, failed values, and timezone assumptions. Even if you rewrite it to TO_DATE, if the argument is already a DATE ...