Its back to basics i think

My datae is stored in MySQL database in this format DD-MM-YYYY HH-MM-SS (the timestamp format)

I need to format this and preferable outside of the MySQL query statement, now what formatting function do i use, i have tried various, with little result.

Cheers people