MYSQL READING DATE FROM CSV

Madam Walker

Total Post:22

Points:154
Posted by  Madam Walker
MYSQL 
 1280  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. AVADHESH PATEL

    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!