How do I do timestamp conversion?

[eluser]Volkof[/eluser]
Hi guys,

Playing with the format of datetime is one of the most irritating thing in programming, for how I feel.

My database has stored a value :

Code:

2013-01-08 20:08:34

When I retrieve it and display in View, I want it to become:

Code:

8th Jan 2013, 8:08pm

I searched through the web. There are so many ways but none of them seems to fit my criteria and it just confuses me

Hope that someone can enlighten me
Thanks in adv