MySQL Forums
Forum List  »  CSV Storage Engine

CSV and Date values
Posted by: Ernesto Oliva
Date: May 24, 2007 05:33AM

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.

Options: ReplyQuote

Written By
CSV and Date values
May 24, 2007 05:33AM
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.