translate timestamp in mySQL to readable

[Anon]

anybody know how to translate the timestamp from mySQL into readable like September 18, 2001

because I got this from timestamp (010918)

[Anon]

I think the function date() is what you need...