This content has been marked as final. Show 3 replies
Pl post details of OS and database versions. What do the "T" and "-08.00" refer to ?
You will need to match the time format that Oracle supports
Thanks for the reply-
SQL Loader is running on Win, Oracle 11 on Linux
The format is standard UTC
YYYY-MM-DDTHH24:MI:SS±HH:MM Where the ±HH:MM refers to time zone offset from GMT. The "T" is just a separator between date and time (and is always "T").
I looked at your references, and tried a few dozen variants without success.
Most of my attempts have been using something similar to this
There is no Oracle mask that matches "2012-05-10T17:04:51-08:00" that I am aware of. You will need to modify your data file to match one of the masks that Oracle supports