Convert Database stored time to normal?

[Max_CR]

Hi. I have the following time. 2012-03-09 16:58:26. I would like to convert it to read "March 9, 2012 - 4:48 PM" How could i do this? Thanks.

[dagon]

mysql ? use the mysql function DATE_FORMAT()

[Max_CR]

perfect! thanks!

[Ashley_Sheridan]

Alternatively, if you prefer this sort of thing being done in PHP (which you might if you need slight variations of the same date in different places) then you can use the date() function.