RE: change format of date fields during LOAD DATA INFILE?

[Jerry Schwartz]

I just tested it with Excel, as it will save the date as seen if you save
the worksheet to a text file. I do this quite a bit, actually, to put
spreadsheet data into MySQL. Often I use Excel macros to construct entire
UPDATE or INSERT statements, and save those into a text file for MySQL to
inhale.

I can't speak for OpenOffice.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: [phone]


> -----Original Message-----
> From: Ferindo Middleton [mailto:ferindo.middleton@stripped]
> Sent: Saturday, October 14, 2006 9:40 PM
> To: mysql
> Subject: change format of date fields during LOAD DATA INFILE?
>
> Is there a way to change the format of date fields MySQL is
> expecting when
> LOADing data from a file? I have no problem with the format
> MySQL saves the
> date but most spreadsheet programs I use don't make it easy
> to export text
> files with date fields in the format YYYY-MM-DD even if I
> formated the field
> that way on-screen.
>
> It would be great if you could tell MySQL on the command line
> to expect
> dates in the format Month/Day/Year or something like that and
> be able to
> interpret that and convert the date to the format it's
> expecting on the fly.
>
> --
> Ferindo
>