Date Convert

Anonymous Monk has asked for the wisdom of the Perl Monks concerning the following question:

Hi Monks!
I have date format like this: "01/09/2012" that is getting inserted into sql server, I am getting errors, I am trying to convert into a sql format, something like this:

...
my $date = "01/09/2012";
$date = strftime '%Y-%m-%d %H:%M:%S', $date;  
print $date;
...
[download]

Any idea on how I could do this?
Thanks!

Back to Seekers of Perl Wisdom