Why we cannot use TIMESTAMP datatype for fields created & modified in cakephp2.x?
cakephp, php, phpmyadmin
Solution
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.
Problem
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