Need to change order of datetime

From DD-MM-YYYY HH:MM:SS to YYYY-MM-DD HH:MM:SS

[The Cricketer]

Hi I have a problem.
I have an HTML form field into which is inserted a date and time in the following European format
21-02-2005 14:07:55
I am trying to insert this datetime into my Mysql database but I cannot get it into the following format before I insert it.
2005-02-21 14:07:55

I just need to know what the way to do this is?
Many thanks.

[buriedUnderGround]

try using substr() to create variables from your original date (ie; $day, $year, $month, $hour, etc) then rearrange those variables to make your new date.

[The Cricketer]

Great thanks. I did something like

$day = substr($drawdatetime,0,2);
$month = substr($drawdatetime,3,2);
$year = substr($drawdatetime,6,4);
$time = substr($drawdatetime,11,8);
$drawdatetime = $year."-".$month."-".$day." ".$time;

[ergophobe]

This should do it:

$date = date [php.net]("%Y-%m-%d %H:%i:%s", strtotime [php.net](21-02-2005 14:07:55 ));