Skip navigation links

MySQL Forums :: Newbie :: LOAD DATA INFILE date format hell


Advanced Search

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


Subject Written By Posted
LOAD DATA INFILE date format hell Gary Thomas 01/23/2007 12:53PM
Re: LOAD DATA INFILE date format hell Bob Field 01/23/2007 01:14PM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/23/2007 01:31PM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/24/2007 08:49AM
Re: LOAD DATA INFILE date format hell Felix Geerinckx 01/24/2007 09:13AM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/24/2007 09:16AM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/24/2007 11:08AM
Re: LOAD DATA INFILE date format hell Felix Geerinckx 01/24/2007 11:41AM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/24/2007 11:51AM
Re: LOAD DATA INFILE date format hell Gary Thomas 01/24/2007 12:12PM
Re: LOAD DATA INFILE date format hell Sandip Karande 02/22/2007 06:04AM
Re: LOAD DATA INFILE date format hell Jason Belec 02/22/2007 08:16AM
Re: LOAD DATA INFILE date format hell kapil gupta 03/21/2007 12:42AM


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.