Import date from csv

krasi_e_d

Hello,guys

I try to import date like dd.mm.yyyy in my csv file the date is dd/mm/yyyy. How to convert data. I use this code:

<?php header("Content-Type: text/html; charset=utf8_unicode"); ?>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html;charset=utf8_unicode" />
</head>
<body>
<?php

$connec = mysql_connect('localhost','root','password');
mysql_select_db('export_ajur', $connec);

$sql = "LOAD DATA LOCAL INFILE 'ena_purchase_invoice.csv'

				INTO TABLE invoice
                FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '\"'
				LINES TERMINATED BY '\r\n'
				IGNORE 1 LINES
                ";
mysql_query($sql);
if(mysql_error()) {
    echo(mysql_error());
} else {
    echo("Import sucessfull data imported to mysql table.");
}
?>

krasi_e_d

I try to import date like dd.mm.yyyy in my mysql database from csv file and the date in the file is dd/mm/yyyy. How to convert data?

bradgrafelman

How are you storing the date in the DB? I would presume that you're using a DATE column, which means you need to convert the date into the standard YYYY-MM-DD format.

For that, you can use MySQL's STR_TO_DATE() function in a 'SET' clause; see the MySQL manual page for the LOAD DATA INFILE syntax for more info/examples.