What will I use to make a fixed format of date in mysql... automatically that format will be the format in php

Question

for example always displays 0000-00-00.... but I want to format 00/00/0000 example 12/04/2007

Answer 1

Store the date in a varchar instead of DATE field specific to MYSQL. You have greater leeway. Then use the date() function in PHP to format the date the way you want to insert it into your db.

I prefer to break the date into 3 seperate parts. yyyy, mm, and dd because it provides for a little more functionality.