problem regarding date value

[greedyisg00d]

I have a table which has a date column which is encoded using excel and then exported as tab delimited text in this date format.

09/23/2009 16:43

My problem is when I import it in phpmyadmin it becomes 0000-00-00 00:00:00
but I set my date field as datetime.

What seems to be the problem?

Thanks

[johanafm]

SQL dates are on the format YYYY-MM-DD. In MySQL you can use whatever delimiter you wish, so YYYY/MM/DD should work as well.