TimeStamp and DateTime are similar. They store in database YYYY-MM-DD HH:MM:SS format. But the difference between them, Timestamp has set time zone (UTC) in footer of store a date. And timestamp has a range of 1970–01–01 00:00:00 UTC to 2038–12–31 03:14:07 UTC, meanwhile datetime has value between 1000–01–01 00:00:00 to 9999–12–31 23:59:59
Advantage of UTC
- If you have many branch of store around the world. You can monitor time to use of customer each country.
Note:
- UTC (Coordinated Universal Time) mean the primary time standard by which the world regulates clocks and time.
- In Mysql TimeStamp can use CURRENT_TIMESTAMP
ref: https://laracasts.com/discuss/channels/laravel/migrations-timestamp-vs-datetime-vs-date-vs-timestamps @michaeldyrynda
