Page is a not externally linkable
- Code, Content, and Presentation
-- Databases
---- CSV into MySQL for Dates - formatting


tec4 - 11:38 pm on Dec 4, 2011 (gmt 0)


Had a quick question,

I have a very large CSV file with dates formatted like 4/29/2005 and would like to insert these values into my MySQL database.

It currently truncates my value and eliminates it by replacing it with 0000-00-00 (currently using the Date format). Is there a way for me to modify either the CSV or DB to correctly transfer the date correctly?


Thread source:: http://www.webmasterworld.com/databases_sql_mysql/4394199.htm
Brought to you by WebmasterWorld: http://www.webmasterworld.com