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.
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Oracle.
© 2021 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy