Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email email@example.com
From: Proemial (proemialgmail.com)
Date: Fri Sep 04 2009 - 09:39:39 CDT
Currently set to:
On Fri, Sep 4, 2009 at 10:24 AM, John
> What is your sql_mode set to?
> I tried inserting that value into a timestamp column on our test server and it works fine.
> John Daisley
> Mobile +44(0)7812 451238
> Email johnbutterflysystems.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 <proemialgmail.com>
> Sent: Friday, September 04, 2009 2:27 PM
> To: mysqllists.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',
> 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