use Time::Piece::MySQL; my $time = localtime->strptime('07/13/2003 21:12','%m/%d/%Y %R'); print $time->mysql_datetime;