Loading data format : DATE and DATETIME
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
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.