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
Subject
Views
Written By
Posted
date format problem
6648
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.