[SOLVED] Reformat Date For MySQL

[maxhugen]

I'm receiving a date from PayPal's IPN in the format '19:51:24 Jul 14, 2008 PDT':

 

$payment_date = $_POST['payment_date'];

 

I need to insert this into a MySQL date field, which is in the format 'yyyy-mm-dd HH:nn:ss'. Can anyone pls suggest how to change the format, as I'm a newbie at PHP?

 

MTIA

[ratcateme]

use date() and strtotime().

 

Scott.

[maxhugen]

Thanks Scott, these date functions rather confuse me, but I got it eventually:

 

    // test example
    $paypal_date = "19:51:24 Jul 14, 2008 PDT";
        echo "paypal_date: ".$paypal_date."<br>";
    $timestamp = strtotime($paypal_date);
        echo "timestamp: ".$timestamp."<br>";
    $mysql_formatted = date("Y-m-d H:i:s",$timestamp);
        echo "mysql_formatted: ".$mysql_formatted."<br>";