Was wondering - well hoping one you guys will be able to help me out?!
I'm trying to add data from an excel file to my DB in mySQL (xampp).
I have managed to add data to all of my tables except one. The data is added when I import it, only problem is the one column is date format - but once its in mySQL it is shown as a integer.
e.g. 28/03/2006 in excel and then once imported to mySQL its shown as 38804.00000
I have tried to change the structure of the table - change the integer field to date format - but that ends up changing all the values under that column to 0000-00-00
Hope one of you guys can help out!