View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 09:33 PM
Ferindo Middleton
 
Posts: n/a
Default 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

Reply With Quote