unix timestamp to normal date

is there a way to convert a unix timestamp to a 05/01/2006 format?

tia.

echo date('m/d/Y', $timestamp);
I'm not sure if the m/d/Y is 100% correct, but it should be close.

Yeah, it's right.

yes you are right, I was just coming back to say nevermind, I found the answer.

Thanks.

You can also do it from the SQL Query.

http://www.hypermedic.com/php/datetime.php