将MySQL的日期时间更改为PHP中可读的文本

Question

I am storing the time a player joins my server using a datetime datatype and inserting a CURRENT_TIMESTAMP. All this done in MySQL.

This will look something like this: 2014-04-14 02:15:03

However, on my website I want to display the time they join but on a more friendly way such as:

April 14, 2014 2:15CST

In a nutshell, how do I change "2014-04-14 02:15:03" into "April 14, 2014 2:15CST"?

Thanks!

Answer 1

Try to use it like the following:

date('F d, Y H:i', strtotime($mysqlTimestamp));

For more details, check the PHP date function at: http://php.net/manual/en/function.date.php