4 ms·
MariaDB: "Use DATETIME as a storage type if you require dates beyond this." https://mariadb.com/kb/en/from_unixtime/ https://mariadb.com/kb/en/from_unixtime/
by rini17 7y ago
MariaDB: "Use DATETIME as a storage type if you require dates beyond this."
https://mariadb.com/kb/en/from_unixtime/ https://mariadb.com/kb/en/from_unixtime/
...so it may end up that nothing will be fixed, just TIMESTAMP will get deprecated.
- ars 7y agoTimestamp automatically handles the timezone, datetime does not. They are not interchangeable. One is used to record an instant in the world, the other to record a specific number for display back without modifying it because of changes in time zone.