MySQL Forums
Forum List  »  Newbie

Re: LOAD DATA INFILE date format hell
Posted by: kapil gupta
Date: March 21, 2007 12:42AM

Sam eproblem here
My csv has date as 01/01/2005, i used

load data local infile 'c:/pet.txt' into table test.test1 FIELDS TERMINATED BY ','(@b)
SET b = str_to_date(@b, '%m/%d/%y');

It gives some warning
Truncated incorrect date value: '11/01/2001
'
but upload data as '2020-01-01'
What coulb be the reason
kapil

Options: ReplyQuote


Subject
Written By
Posted
Re: LOAD DATA INFILE date format hell
March 21, 2007 12:42AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.