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