为什么我们不能将TIMESTAMP数据类型用于cakephp 2.x中创建和修改的字段？

Question

As we know MYSQL datetime datatype taking more memory that TIMESTAMP. For rapid development I am using cakephp2.x. My concern is why we are not using TIMESTAMP for created and modified field in database.? I read cakephp2.x document, they not mention the reason in technical terms clearly. Expect good answer from expert!

Thank you in advance

Answer 1

The main difference is that DATETIME is constant while TIMESTAMP is affected by the time_zone setting.

Also, the space needed for both can be seen as pretty much identical if you don't have billions of rows (4 bytes Vs 8 bytes, but still nothing really). the datetime fields can also be used for easy comparison and calculation.

My recommendation: So just stick to datetime and don't create an issue where there is none really. There are usually way more troubling issues at hand when starting to develop an application.