I have a CSV file with the timestamp in the following format
timestamp, day_chan2, day_chan3 01/02/2014 00:00, 9, 2 01/02/2014 00:00, 16, 5
I am trying to import it into a MySQL database using LOAD DATA INFILE
$query_name = "LOAD DATA INFILE ' " . $file_path . "' INTO TABLE '" . $this->table_name . " ' FIELDS TERMINATED BY '\,' LINES TERMINATED BY '\ ' IGNORE 1 LINES (`time_stamp`,`day_chan2`,`day_chan3`)";
My problem is the following: how do I convert the timestamp into a format acceptable to my MySQL while importing it into the database?
I am clueless now on how to change the timestamp into a proper timestamp which I can use to query later.