RE: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread John Daisley
Is your table innodb? If so i think the 'STRICT_TRANS_TABLES' sql_mode 'may' be causing the problem. Try inserting the value as '2008-03-09 02:56:34.737' Do you get the same error? What mysql version is your server? Regards John Daisley Mobile +44(0)7812 451238 Email

Re: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread Proemial
I had already tried that, actually. Produces the same error. I should have mentioned that as well, sorry! The version is 5.1.34 thanks for the help, btw! Martin On Fri, Sep 4, 2009 at 11:14 AM, John Daisleyj...@butterflysystems.co.uk wrote: Is your table innodb? If so i think the

RE: Fwd: Help with Timestamp invalid value error

2009-09-04 Thread Gavin Towey
with Timestamp invalid value error I had already tried that, actually. Produces the same error. I should have mentioned that as well, sorry! The version is 5.1.34 thanks for the help, btw! Martin On Fri, Sep 4, 2009 at 11:14 AM, John Daisleyj...@butterflysystems.co.uk wrote: Is your table