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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

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

Did this article solve an issue for you?

Select Rating

Title