02
Sep
Learn datetime vs timestamp in mysql
Q: What would you recommend using between a datetime and a timestamp field in mysql, and why?
A: Generally Timestamps in MySQL used to track changes to records, and are updated every time the record is changed. If you want to store a specific value you should use a datetime field.
If you meant that you want to decide between using a UNIX timestamp or a native MySQL datetime field, go with the native format. You can do calculations within MySQL that way
(“SELECT DATE_ADD(my_datetime, INTERVAL 1 DAY)”)
and it is simple to change the format of the value to a UNIX timestamp
(“SELECT UNIX_TIMESTAMP(my_datetime)”)
when you query the record if you want to operate on it with PHP.