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

Thanks,

--jim

Thread
LOAD & date typesjkraai12 Apr
  • Re: LOAD & date typesPaul DuBois12 Apr
Re: LOAD & date typesjkraai12 Apr