PHP - date string to Mysql dateTime

Question

I have to convert a string like 'Wed, 29 Jan 2014 13:35:01 +0000' to a MySQL dateTime in PHP which can be entered straight into the db, could someone help please? btw, I have no use of the +0000 thanks

John Conde · Accepted Answer · 2014-01-29 21:19:53Z

1

DateTime() can convert this easily:

$dt = new DateTime('Wed, 29 Jan 2014 13:35:01 +0000');
echo $dt->format('Y-m-d H:i:s');

See it in action

answered Jan 29, 2014 at 21:19

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Mark Baker Over a year ago

Or if you're using PHP 5.5+: echo (new DateTime('Wed, 29 Jan 2014 13:35:01 +0000'))->format('Y-m-d H:i:s');

Collectives™ on Stack Overflow

PHP - date string to Mysql dateTime

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related