Skip navigation links

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


Advanced Search

Re: LOAD DATA INFILE date format hell
Posted by: Bob Field ()
Date: January 23, 2007 01:14PM

LOAD DATA INFILE 'file_name'
    INTO TABLE tbl_name
    FIELDS TERMINATED BY ','
    (columns..., @date, morecolumns...)
    SET datecolumn = date_format(str_to_date(@date, '%d-%M-%Y'), '%m/%d/%Y');

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.