I don't use the DateTime modules, but the Time::Piece::MySQL module will convert to and from MySQL date strings.

use Time::Piece::MySQL;
my $time = Time::Piece->from_mysql_datetime( $mysql_datetime );

print $time->mysql_datetime;
[download]

You might be able to use it, or learn enough to write your own module.

- Cees