Currently set to: NO_AUTO_VALUE_ON_ZERO,STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION
On Fri, Sep 4, 2009 at 10:24 AM, John Daisley<j...@butterflysystems.co.uk> wrote: > 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] > -- --- 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
