MySQL reading date from CSV

Total Post:22

Points:154
MYSQL 
 1584  View(s)
Ratings:
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. 

  1. Post:604

    Points:4228
    Re: MySQL reading date from CSV

    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. 

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!