RE: Reading Date from a csv file

[David Sears]

Try 'yyyy-mm-dd'.

-----Original Message-----
From: Lakshmi Chennareddi [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 10:18 AM
To: [EMAIL PROTECTED]
Subject: Reading Date from a csv file


I am new to mySQL.

I am trying to import data from a csv file, using the following code

LOAD DATA LOCAL INFILE 'D:/foldername/file1.csv'

    INTO TABLE database_name.tbl_name

    FIELDS TERMINATED BY ','

              (

        field1,

       field6_date,

        field9

               );



The data is getting imported, but the dates are wrong.

In the original data file the dates are "mm/dd/yy" format. How do I specify
the date formats, in the code?



Thanks in advance for any help,

Lakshmi








-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]