there are three ways to accomplish this:
first is to load it in to excel or whatever and format the column as yyyy-mm-dd h:mm:ss, then save.
second is to create a staging table in the database where this column is varchar. load the CSV file in to that table, then use INSERT ... SELECT to move the rows to the correct table, and use date formatting or string manipulation functions to get the dates in there correctly.
third option is just like the second, but instead of a staging table, use LOAD DATE INFILE to reformat the dates. here's an example from the mysql manual:
LOAD DATA INFILE 'file.txt'
INTO TABLE t1
SET column2 = @var1/100;