如何在PHP中格式化MySQL中的时间戳？

Question

When I directly echoed a timestamp value I retrieved from a database in PHP, I saw this on my screen.

2012-04-01 12:02:00

What is an efficient way to parse this timestamp string in PHP? Should I use regex or explode to turn this timestamp into two strings and parse each one (date and time)?

Is there a more streamlined and standard way to do this?

In the end, I want to present this timestamp as: 12:02 on April 1, 2012.

Answer 1

date('H:i on F d, Y',strtotime('2012-04-01 12:02:00'))

More info on date pattern here: http://php.net/manual/en/function.date.php