Hi Guys,

Any ideas how i can convert dates like "Wed Nov 24 08:27:52 2010" to "2010-11-24 08:27:52"

So i can insert the orginal date into a mysql DB with the new date format

Thanks
Graham

No worries, Ive done a nasty hack that seems to work fine!

PHP Code:

# Format = Sat Dec 11 11:15:19 2010
# New format = 2010-12-31 10:08:00

$line = "Sat Dec 11 11:15:19 2010 SOME OTHER ****TY DATA NOT NEEDED";
// Change date format
$time = substr($line, 0, 24); // Get date.
$chunks = preg_split('/\s+/', $time);

$month = $chunks[1];
switch ($month){
        case "Jan":
                $month = "01";
        break;
        case "Feb":
                $month = "02";
        break;
        case "Mar":
                $month = "03";
        break;
        case "Apr":
                $month = "04";
        break;
        case "May":
                $month = "05";
        break;
        case "Jun":
                $month = "06";
        break;
        case "Jul":
                $month = "07";
        break;
        case "Aug":
                $month = "08";
        break;
        case "Sep":
                $month = "09";
        break;
        case "Oct":
                $month = "10";
        break;
        case "Nov":
                $month = "11";
        break;
        case "Dec":
                $month = "12";
        break;
}
$time = "$chunks[4]-$month-$chunks[2] $chunks[3]";

// Now echos $time as 2010-12-22 17:06:51 for example :) YAY 


Use strtotime to convert the date to a timestamp and then use date to format it however you want:

PHP Code:

$time = strtotime('Wed Nov 24 08:27:52 2010');
echo date('Y-m-d H:i:s', $time); 


Originally Posted by NullPointer

Use strtotime to convert the date to a timestamp and then use date to format it however you want:

PHP Code:

$time = strtotime('Wed Nov 24 08:27:52 2010');
echo date('Y-m-d H:i:s', $time); 


Cool, Would of been simpler
Was in a rush.

Might change it to the above.