List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:April 12 1999 6:24pm
Subject:Re: LOAD & date types
View as plain text  
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.

--
Paul DuBois, paul@stripped
Northern League Chronicles: http://www.snake.net/nl/
Thread
LOAD & date typesjkraai12 Apr
  • Re: LOAD & date typesPaul DuBois12 Apr
Re: LOAD & date typesjkraai12 Apr