Advice on handling date preferences

[eluser]CroNiX[/eluser]
I personally prefer datetime over timestamps as it's a lot easier to use mysqls powerful built-in time/date functions without converting.

http://stackoverflow.com/questions/40928...-timestamp

You can easily format the desired date output as part of the query or use strtotime() during output.

Timestamps also have an upper limitation to the year 2038, which isn't that far off.