ksduded Posted April 11, 2008 Share Posted April 11, 2008 I am importing a excel converted csv file to mysql through phpmyadmin. The excel file has a date field, which is formatted as yyyy-mm-dd, but the input is in the form of dd/mm/yyyy. Once i save this excel file as a csv it stores the date in the dd/mm/yyyy format which imports as 0000-00-00 in the mysql database. There are two ways to get around this. Either conver the formatted date (yyyy-mm-dd) in excel to string and then convert to csv for import. Or somehow change the import options through phpmyadmin. Please guide. Thanks Quote Link to comment Share on other sites More sharing options...
mwasif Posted April 11, 2008 Share Posted April 11, 2008 Either conver the formatted date (yyyy-mm-dd) in excel to string and then convert to csv for import. This is the option or you can import date data in a varchar column and then use string functions to extract data in date format and update in date column. Quote Link to comment Share on other sites More sharing options...
ksduded Posted April 11, 2008 Author Share Posted April 11, 2008 i know this is a php mysql forum, but does anyone know how to convert the date to a string and have it saved in the same input field Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.