MySQL Forums
Forum List  »  General

Loading data format : DATE and DATETIME
Posted by: Dominique Duay
Date: November 18, 2004 09:00AM

Hi,

I'm trying to load data into MySQL with

LOAD DATA INFILE '/u00/app/mysql/local/test/ADR.csv' INTO TABLE ADR
FIELDS TERMINATED BY '|' LINES TERMINATED BY '\n';

The date format in my file is %d.%m.%Y.

How can I tell mysql that the date format which is coming is not %Y-%m-%d but the one above ?

Can I start Mysql with an other date format ?
Can I set a session variable do it ?

Thanks
Dom

Options: ReplyQuote


Subject
Written By
Posted
Loading data format : DATE and DATETIME
November 18, 2004 09:00AM


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.