MySQL Forums
Forum List  »  Newbie

LOAD DATA INFILE date format hell
Posted by: Gary Thomas
Date: January 23, 2007 12:53PM

Hello all

I am trying to import a csv file into mysql that has a date field.
I have got most of it to import but there is a problem importing the date field, the date in the csv file is formatted like this 01-Jan-2007.

I need to change the date format to 01/01/2007 or 01/01/07 in the load data infile query. How do I do this?

Any help on this matter would be appreciated.

Many Thanks in advance

Gary Thomas

Options: ReplyQuote

Written By
LOAD DATA INFILE date format hell
January 23, 2007 12:53PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.