in reply to Convert date format in database table.

I like Zaxo's idea, but do check out Matts's Marty Pauley's Time::Piece::MySQL 
use Time::Piece::MySQL;

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

[download]

jeffa

L-LL-L--L-LL-L--L-LL-L--
-R--R-RR-R--R-RR-R--R-RR
B--B--B--B--B--B--B--B--
H---H---H---H---H---H---
(the triplet paradiddle with high-hat)

In Section Seekers of Perl Wisdom