ansaurus

Question

Answer 1

+3 A:

date_default_timezone_set('America/New_York');
$timestamp = "2009-11-05 22:51:26";
echo date('H:i e j M Y l', strtotime($timestamp)); //22:51 America/New_York 5 Nov 2009 Thursday

See date() for a list of format parameters. I matched your requested output pretty closely but you may want to tweak it

strtotime() - Parse about any English textual datetime description into a Unix timestamp

Mike B 2009-11-06 19:37:28

Will this work for variable timestamps? It looks like the variable $timestamp you suggest is static.

John 2009-11-06 19:45:30

yes, it will. I'm sure Mike B is just doing that as an example.

GSto 2009-11-06 19:49:06

What do you mean variable timestamps? Like I said in my answer, strtotime() parses just about any datetime format.

Mike B 2009-11-06 20:09:10

That will not convert the timezone properly. strtotime($timestamp) needs to be called *before* date_default_timezone_set(), otherwise it will interpret the timestamp as the new default timezone and not the timezone on the server. TIMESTAMP values are converted to the server's timezone on retrieval. Also note, date_default_timezone_set() only works in PHP >= 5.1.0.

Jason 2009-11-06 20:09:12

@Jason Good point. However, as John stated in his question, the datetime string has already been retrieved from the database and is in US/East. I assumed this was true in my response. If this is not the case then my answer will need to be tweaked.

Mike B 2009-11-06 20:15:58

ansaurus

tags:

views:

answers:

Formatting a timestamp

related questions