MySQL Bugs: #1177: ALTER TABLE MODIFY timestamp column to datetime type

1,null,'blah'); Query OK, 20 rows affected (0.01 sec) Records: 20 Duplicates: 0 Warnings: 0 mysql> ALTER TABLE category MODIFY date_deleted DATETIME; Query OK, 20 rows affected (0.02 sec) Records: 20 Duplicates: 0 Warnings: 0 [5 Sep 2003 2 ...

bugs.mysql.com