CSV and Date values
Hi,I'm trying to Load a data file to MySQL 5.0 I'm having problems with a DATE value in the csv file becouse don't accept the EUROPE format
e.g I have a value 06/05/2007 and MySQL throws me an error :
Incorrect date value: '06/05/2007' for column 'fecha' at row 1
If I put the right format 2007-05-06 work and when I list the table show me the value 06/05/2007 .
What I must do for MySql accept this format(dd/mm/yyyy) from an csv file becouse I test with functions and not accepts.
Subject
Views
Written By
Posted
CSV and Date values
12731
May 24, 2007 05:33AM
6464
August 09, 2007 10:49PM
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.