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.