4 ms·
MySQL appears to still be mulling it over. https://bugs.mysql.com/bug.php?id=12654 https://bugs.mysql.com/bug.php?id=12654
by tyingq 7y ago
MySQL appears to still be mulling it over. https://bugs.mysql.com/bug.php?id=12654 https://bugs.mysql.com/bug.php?id=12654
- rini17 7y agoMariaDB: "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.