Formatting Date with PHP from weird twitter format

Question

Through the twitter API I was able to get the datetime of when something was tweeted

Jul 25 17:42:55 +0000 2013

Now, in PHP, how do I get that into standard unix:

2013-6-25 17:42:55

I'm not to sure on anything to deal with datetime but I think there is an easier way to do this rather than having to parse through and change things with str_replace and substr

Phil · Accepted Answer · 2013-07-26T03:53:07.380

9

Use the DateTime class, specifically the static createFromFormat() method

$dt = DateTime::createFromFormat('M j H:i:s P Y', 'Jul 25 17:42:55 +0000 2013');
echo $dt->format('Y-m-d H:i:s');

Working example - http://codepad.viper-7.com/gLdEll

edited Jul 26 '13 at 03:53

answered Jul 26 '13 at 03:46

Phil

157,677
23
242
245

11

Twitter feed stamps look like "Mon Sep 08 15:19:11 +0000 2014", correct format for these is $d = \DateTime::createFromFormat('D M d H:i:s P Y', (string)$x->created_at); – Saeven Sep 09 '14 at 17:04

DevZer0 · Answer 2 · 2013-07-26T03:58:28.933

8

Simply pass it through strtotime. Note that this includes a timezone +0000 so the time will translate relative to your timezone also.

<?php
$date = "Jul 25 17:42:55 +0000 2013";
echo date("Y-m-d H:i:s", strtotime($date));

edited Jul 26 '13 at 03:58

answered Jul 26 '13 at 03:45

DevZer0

13,433
7
27
51

This also works I suppose, I got strtotime to work, but it wasn't suiting my needs. Thank you for your input though – Joel Werner Jul 26 '13 at 03:52
Also, you probably want `H`, not `h` – Phil Jul 26 '13 at 03:57
With this, Tue Jan 27 21:53:43 +0000 2015 gets translated as 2015-01-27 15:53:43. The hour is not same. – Jeremy Jan 28 '15 at 14:41
@Jeremy time gets translated relative to your timezone. please read my post :-) – DevZer0 Jan 29 '15 at 04:04

Formatting Date with PHP from weird twitter format

2 Answers2