When attempting to import a CSV file, the CSV importer is not correctly recognizing time values (originally in 12-hour format). These same time values were correctly recognized when imported using an .xlsx file. An important note: in SQL/SSMS, the datatypes for the "Time" fields in question are datetime, as there is no datatype for only time (I believe this is correct).
The times need to be in a 24-hour format for the CSV importer, but the importer still failed to correctly recognize those time values after the conversion (essentially it imports the column, but with no values). Only after going into the CSV and appending a date to these times (thus creating datetime in 24-hour format) was the CSV importer able to correctly recognize the time values and display them properly in the importer preview grid.
When attempting to import a CSV file, the CSV importer is not correctly recognizing time values (originally in 12-hour format). These same time values were correctly recognized when imported using an .xlsx file. An important note: in SQL/SSMS, the datatypes for the "Time" fields in question are datetime, as there is no datatype for only time (I believe this is correct).
The times need to be in a 24-hour format for the CSV importer, but the importer still failed to correctly recognize those time values after the conversion (essentially it imports the column, but with no values). Only after going into the CSV and appending a date to these times (thus creating datetime in 24-hour format) was the CSV importer able to correctly recognize the time values and display them properly in the importer preview grid.