Home > DeveloperSection > Forums > MySQL reading date from CSV
Madam Walker
Madam Walker

Total Post:22

Points:154
Posted on    July-09-2013 3:03 AM

 MYSQL MYSQL 
Ratings:


 1 Reply(s)
 929  View(s)
Rate this:
Hi Expert,

Right now I have a database in the format with columns:

id - purchase_date - integer fields.....
And an import of a CSV using the script

LOAD DATA LOCAL INFILE 'C:/Users/Alex/Desktop/work/natgas2.csv' INTO TABLE pricemodel.natural_gas 
   FIELDS
        TERMINATED BY ',' 
        ENCLOSED BY '"'
        LINES TERMINATED BY '\r\n';
And everything's being imported correctly except for the dates which are in the format right now of:

1/3/2011
So the question is what format do they have to be in for them to be read correctly into my database?

Please help?

Thanks in advance. 



AVADHESH PATEL

Total Post:604

Points:4228
Posted on    July-09-2013 4:36 AM

Hi Madam!

Try as following line of code

YYYY-MM-DD HH:MM:SS (24-hour time)

If the field is of type timestamp.

For example:

2011-01-03 00:00:00

I hope it resolve your problem. 


Don't want to miss updates? Please click the below button!

Follow MindStick