Using a custom date format when importing data no longer imports the date correctly (83845)

Chat now with support

Return

Feedback submitted.

Was this article helpful?

[Select Rating]

Title

Using a custom date format when importing data no longer imports the date correctly
Description

When using the import Table Data Feature I have a date that is not importing correctly using TOAD for Oracle 11.0.0.116. The dates loaded correctly using TOAD for Oracle 10.6. The format of the date in the spreadsheet is 122704. I chose Date Order Custom and then type mmddyy (as I did on 10.6). However, now the data loads as 12/13/2235, instead of 12/27/2004.
Resolution

WORKAROUND:
None

STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
Defect ID

ST91935

Feedback submitted.

Was this article helpful?

[Select Rating]

Title