Datetime or Timestamp for a MySQL field?

Question

Hi, This one is a question I have asked myself several times, when creating Databases for PHP/MySQL web application.

In Mysql, what'd you recommend between Datetime and Timestamp and why?.

Answer 1

Even if you are changing the server time zone you can make use of timestamp. Date may not

For time zone conversion also Time stamp is easy

Answer 2

I prefer datetimes stored in the UTC timezone because it is not based on some arbitrary time period, is easier to read, and lends itself nicely to a variety of database date functions.

But I don't fuss over this... if I have to work on a project that uses timestamps, it doesn't bother me.