making mysql timestamp look friendly

Hello,

I have a mysql field with a timestamp field. I'm using php to display it and it prints like "000815"

My question is:

Is there a way to make this display more friendly, ie: August 15, 2000

Thanks for your help!

Use the DATE_FORMAT function. To get a date formatted how you want:
select DATE_FORMAT( date_column, '%M %e, %Y' ) from mytable;

Oh, URL to details about date functions:
http://www.mysql.com/documentation/..._time_functions

Thank you.

Is this format:

select DATE_FORMAT( date_column, '%M %e, %Y' ) from mytable;

usable in php?

You use it just like any other mysql query:

$result=mysql_query("foo");