I've got a csv file that has date/time represented in two columns as:
entrydate: 2012-04-06 11:12:40.000
shipdate: 4/7/2012 12:20:31 PM
I've got my sql table set up as:
[entrydate] [datetime] NULL,
[shipdate] [datetime] NULL,
when i try to import there is a conversion failure on the shipdate. so i switched the data type to a varchar 100 and it loads. What is the better data type for the shipdate column? Should i keep it at a varchar?