Return
-
Title
Import Table Data incorrectly importing AM date/times as PM -
Description
Importing data from a text file (fixed width or delmited) imports incorrect AM/PM setting
The data seems to map correctly within the wizard showing AM for the time. But after the data has been improted, the actual data saved to the table shows PM. Time will be in PM instead of AM. Note that this does not happen for Excel files.Example:If trying to import the date/time: 12/13/1999 12:28:22 AM
The Import Table Data wizard will display the AM setting correctly but after it's been imported, querying the database will return the incorrect data of: 12/13/1999 12:28:22 PM -
Resolution
WORKAROUND:
User Excel to import the data.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
-
Defect ID
ST84553 -
Additional Information
This is only an issue if the time is in the 12:00 hour. This can happen for both DATE and TIMESTAMP datatypes.