try ISO standard dates YYYYMMDD ----- Original Message ----- From: "Lakshmi Chennareddi" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, September 16, 2003 4:17 PM 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]