maxhugen Posted July 15, 2008 Share Posted July 15, 2008 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 Quote Link to comment https://forums.phpfreaks.com/topic/114771-solved-reformat-date-for-mysql/ Share on other sites More sharing options...
ratcateme Posted July 15, 2008 Share Posted July 15, 2008 use date() and strtotime(). Scott. Quote Link to comment https://forums.phpfreaks.com/topic/114771-solved-reformat-date-for-mysql/#findComment-590128 Share on other sites More sharing options...
maxhugen Posted July 15, 2008 Author Share Posted July 15, 2008 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>"; Quote Link to comment https://forums.phpfreaks.com/topic/114771-solved-reformat-date-for-mysql/#findComment-590156 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.