convert freindly date and time to mysql format 1

[pushyr]

is there a simple way to convert a friendly date and time to a mysql format

my date and time looks like this...
Tue, 31 Jul 2012 13:17:23 GMT

and i'd like to both split and convert into this...

1. 2012-07-31
2. 13:17:23

 

[jpadie]

date_default_timezone_set('Europe/Paris');
$time = strtotime('Tue, 31 Jul 2012 13:17:23 GMT');
echo date('Y-m-d', $time);
echo "\r\n\";
echo date('H:i:s', $time);

please note that GMT is not the same as BST. It is safest to rely on UTC for time stamps. then do the conversions to local time when you use the datum

 

[pushyr]

cheers jpadie... i knew it were something simple like that!