in reply to Convert date format in database table.

I would mung the CSV file using perl and one of the CSV modules, then import the whole thing to mysql, with the proper DATETIME column type for that data.

After Compline,
Zaxo

  • Comment on Re: Convert date format in database table.

In Section Seekers of Perl Wisdom