This solves the most difficult part of your problem. I'm not sure if there is a module that handles the conversion to MySQL format--in the past I've used localtime to do these types of conversions.

Well, I don't know exactly what you are looking to do to "validate date", but the conversion is pretty straight forward:

my $date = "12-02-2000";
(my $out = $date) =~ s/(\d{1,2})-(\d{1,2})-(\d{2,4})/$3\-$1\-$2/;
[download]

Printing $out returns 2000-12-02. Sure, you can shorten it some, or use different syntax, but this should handle most of these date conversions.

Of course, the standard "use strict" and "-w" recommendations apply.

Well I would do it like the above and I guess the validation could be included also.

$date="24-02-2000";

if ($date =~ /(\d{2})-(\d{2})-(\d{4})/){
  $month=$1;$day=$2,$year=$3;
  print "ERROR month invalid",$month="01","\n" if($1 > 12);
  print "ERROR day invalid",$day="01","\n" if($2 > 31);
  print "ERROR year invalid",$year="2000","\n" if($3 > 2100 || $3 < 19
+00);
  $new_date = $year."-".$month."-".$day;
}
print "$new_date\n";
[download]

You could be as fancy with the validation as you want.
tidy up the code as much as you desire

$test_date = "12-02-2001";

if ($test_date =~ s/^([0-1]?\d)\-([0-3]?\d)\-([0-9]{4})$/$3\-$1\-$2/) 
+{
print $test_date;
} else {
print "boom";
}
[download]

HTH,

Update thought about it, shortened it and corrected it. Sorry for the original error in it.

EEjack