Best format to save date?

[eluser]xwero[/eluser]
You can do that with datetime too, but there you have to format the date in the model.

If you look at readability datetime and date is the format you want, if you look at storage space int is the best. If you only need the date, the date datatype is the easiest to manipulate.
If you know which are the formats of the output you can build it into the model. If you want to let a front-end programmer decide which form it's going to be you better use an integer datatype.

There is no correct answer as both ways work. The question is where are you going to handle the date formating and manipulations, in sql or in php?