I have a CSV file that I am importing into MySQL using PHP but the problem is that the timestamp is in the following format
01/02/2014 00:00:00
I have read about MySQL timestamp and it only accepts in the following format
01-02-2014 00:00:00
from what I know. I am wondering if there is a way that I can convert the column which I have set as varchar into timestamp and convert it into a format that MySQL will accept ?
Is there an SQL query or a PHP function that I can use to do this? Also, the no of rows exceeds more than a million so I want it to be as fast as possible.
Any suggestions would be appreciated.