Help: Simple time/timestamp php

I have a problem,

In the database I have several dates, in timestamp format e.g...

2009-12-04 22:20:50
(YYYY/MM/DD HH:MM:SS)

How can I make it (-without changing mysql, -so in php/code) so it displays it like
Day:Month:Year, HH:MM:SS i.e:

4th December 2009 22:20:50?

Thanks,

James

 

You can do this in your SELECT query. Use "DATE_FORMAT": http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

Will become something like this:

SELECT id, title, DATE_FORMAT(created,'%D %M %Y %H:%i:%s') FROM table

Code (markup):