LOAD DATA INFILE date format hell
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
Subject
Written By
Posted
LOAD DATA INFILE date format hell
January 23, 2007 12:53PM
February 22, 2007 06:04AM
February 22, 2007 08:16AM
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.