Hi, There seems to be a problem with setting default values for the timestamp column type in version 4.0.17:
mysql> create table test (t timestamp default '2001-01-01 00:00:00' not null); ERROR 1067: Invalid default value for 't' In 4.0.16 this works normally: mysql> create table test (t timestamp default '2001-01-01 00:00:00' not null); Query OK, 0 rows affected (0.00 sec) This also occurs when using other formats (YYYYMMDDHHMMSS and smaller), so the timestamp column is practically broken when it comes to default values. Regards, -- Predrag Malicevic BLIC.NET ISP +387-51-240-830 http://www.blic.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]