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

print $time->mysql_datetime;