DATETIME vs TIMESTAMP

[Eiolon]

I've been using DATETIME to store my dates and times in MySQL.  Is there any reason why I should use TIMESTAMP over it besides it being 4 bytes compared to 8 bytes?

[Rhysyngsun]

The problem with TIMESTAMP is that if you don't supply a value or pass null to it when updating/inserting it will use the current server time. Use datetime unless you want this automatic functionality.