Need Help With Formatting Date

[eluser]megabyte[/eluser]
Why not just use MySql and let it do all the work? I myself once upon a time used PHP for everything, but MySql makes it so much easier.

Code:

SELECT DATE_FORMAT(your_date_field, '%m/%d/%Y') as formated_date