<div>
For future reference when working with date/time values in PHP and MySQL:<br />
<a href="https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html" rel="ugc">https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html</a>
</div>


For future reference when working with date/time values in PHP and MySQL:
https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html [https://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html]

<div>
<div class="content wysiwyg-content">
I have been given an XML data feed containing dates which look like this:<br />
<br />
&lt;pubDate&gt;Mon, 10 Aug 2015 19:23:30 +0000&lt;/pubDate&gt;<br />
<br />
I need to convert that into Y-m-d H:i:s for insert via WordPress' wp_insert_post which requires that format. Its very strict, I tried using &quot;8&quot; for August and it errored out, required me to use &quot;08&quot;.<br />
<br />
My question is, what is the best way to go about this? I could obviously pick it apart piece by piece with a bunch of PHP script but that seems wasteful. Is there a better way?<br />
<br />
Thanks!
</div>
</div>


I have been given an XML data feed containing dates which look like this:

<pubDate>Mon, 10 Aug 2015 19:23:30 +0000</pubDate>

I need to convert that into Y-m-d H:i:s for insert via WordPress' wp_insert_post which requires that format. Its very strict, I tried using "8" for August and it errored out, required me to use "08".

My question is, what is the best way to go about this? I could obviously pick it apart piece by piece with a bunch of PHP script but that seems wasteful. Is there a better way?

Thanks!

Convert date format in PHP to Y-m-d H:i:s

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.