Reply to topic
Fixing Date format in CSV for import to mySQL
kirkdickinson


Joined: 08 Nov 2008
Posts: 2
Post Posted: Sat Nov 08, 2008 5:10 am Reply with quote
I have several tables that won't import the dates correctly into mySQL because they are formatted incorrectly. My database tables all show the dates MM/DD/YYYY and it seems that mySQL wants them in this format YYYY-MM-DD.

The tables import, but the dates are all zeroed out 0000-00-00

I surely am not the first person to have this problem.

Thanks,

Kirk
Fixing Date format in CSV for import to mySQL
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
 		All times are GMT  
Page 1 of 1  
  
  
 Reply to topic