how to change date format

[eluser]jrtashjian[/eluser]
I normally store dates as a timestamp in the database and use PHP's date() to format it. Makes everything easier. I know you can use DATE_FORMAT() to format it directly in MySQL however, I'm pretty sure you can only store dates using the "-" separator not the "/". Which tells me you're most likely storing the date in a varchar() column and not a date() column.