I run a process which loads a series of timestamped data into a table. I use the TIMESTAMP column.
I have a single value with a timestamp of '2008-03-9 2:56:34.737' which fails on insert with 'incorrect datetime'. Days before, and after work. Hours later in the day work. I thought it might be related to the timezone, but have none of the TZ tables populated. Can someone tell me why this date in particular fails? The query that fails: INSERT INTO secondarydata.trs_newslist (`timestamp`, TRStoryID, topic_list, product_list) VALUES ( '2008-03-9 2:56:34.737', '', '', '') Table: newsID int(10) unsigned PRI auto_increment timeStamp timestamp CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP TRStoryID varchar(128) topic_list varchar(512) product_list varchar(512) Thank you! Martin -- --- This is a signature. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
