The SQL worksheet pane is capable of using TO_DATE with the YYYY-MM-DD"T"HH24:MI:SS"Z" mask to parse Data Type DATE strings in the ISO_INSTANT format (e.g. 2021-07-20T20:20:27Z).
However when asked to import data using the same mask, the status message in the Data Import wizard's Column Definition pane says "Data is not compatible with column definition or is not available for a not nullable column" , regardless of whether the column is checked nullable or not.
Changing the Format field to "YYYY-MM-DD'T'HH24:MI:SS'Z'" (with the double quotes around the outside) yields the same error, suggesting whatever's parsing the input in the Format field is either trying to escape the double quotes or otherwise not pass it literally – or the application's code isn't calling Java's DateTimeFormatter parser consistently/correctly on the Format field and/or the data.
Other experiments add the error "Invalid format {mask} is specified." to the top of the status message, so clearly something's trying to match the mask to the data.
As the below image shows, the data is compliant ISO 8601 format for the mask. This problem has been noted in places like StackOverflow going back years. This is a fairly standard data format and the documentation implies Format recognizes standard masks.
Can this be corrected in the next release?
