What is your sql_mode set to? I tried inserting that value into a timestamp column on our test server and it works fine.
Regards John Daisley Mobile +44(0)7812 451238 Email j...@butterflysystems.co.uk Certified MySQL 5 Database Administrator (CMDBA) Certified MySQL 5 Developer Cognos BI Developer ----------------------- Sent from HP IPAQ mobile device. -----Original Message----- From: Proemial <proem...@gmail.com> Sent: Friday, September 04, 2009 2:27 PM To: mysql@lists.mysql.com Subject: Help with Timestamp invalid value error 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) [The entire original message is not included] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
