From: jkraai
Date: April 12 1999 7:08pm
Subject: Re: LOAD & date types
List-Archive: http://lists.mysql.com/mysql/1717
Message-Id: <001301be8517$ec435410$8b7125a6@cpda6686.mcit.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Paul,

Looks like 28 lines of Python to the rescue.

Thanks.

--jim

-----Original Message-----
From: Paul DuBois <paul@stripped>
To: jkraai@stripped <jkraai@stripped>; mysql@stripped
<mysql@stripped>
Date: Monday, April 12, 1999 1:25 PM
Subject: Re: LOAD & date types


>At 1:09 PM -0500 4/12/99, jkraai@stripped wrote:
>>hi!
>>
>>Minor problems loading data from text file.
>>
>>Source:
>>    Progress 4GL on AIX.  Exported date format "MM-DD-YY".
>>Can't seem to change the format of this field--nowhere in the export
>>builder to specify field formats.
>>
>>Destination:
>>    MySQL (3.22.14-gamma) field spec "date".
>>
>>LOAD DATA INFILE '...' brings this in as 0000-00-00.
>>
>>I could load data into another file with this column defined as a char,
>>then bring it into the real file, is this necessary?
>
>
>Either that, or reformat the date in the file that you read in with
>LOAD DATA.