MySQL Forums
Forum List  »  CSV Storage Engine

date format problem
Posted by: ch faisal
Date: February 21, 2011 03:31AM

I have the following file in CSV format:

7,748857bb01f0731b58bbabd13a88bfad,http://www.coloradoboomerangs.com/,Colorado Boomerangs,12/15/2005 19:31

When I use import statement from mysqladmin in order to import this csv file into a table in mysql then populated date column show date and time in (0000-00-00 00:00:00) format, which is given below:

12 2f87c060c8ada01d4500 http://www.cs.stir.ac.uk/~kjt/ BibTeX Style Examples 0000-00-00 00:00:00

How can I solve this problem so date should be populate like this

12 2f87c060c8ada01d4500 http://www.cs.stir.ac.uk/~kjt/ BibTeX Style Examples 12/15/2005 19:31

Regards

Options: ReplyQuote


Subject
Views
Written By
Posted
date format problem
6515
February 21, 2011 03:31AM


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.