RE: Fwd: Help with Timestamp invalid value error
Mysql doesn't store sub-second values. try 2008-03-09 02:56:34 Instead of 2008-03-09 02:56:34.737 Regards, Gavin Towey -Original Message- From: Proemial [mailto:proem...@gmail.com] Sent: Friday, September 04, 2009 8:37 AM To: John Daisley Cc: mysql@lists.mysql.com Subject: Re: Fwd: Help 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 Daisley wrote: > 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 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 > Sent: Friday, September 04, 2009 3:39 PM > To: mysql@lists.mysql.com > Subject: Fwd: Help with Timestamp invalid value error > > 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 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. >> >> >> > > > [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=gto...@ffn.com The information contained in this transmission may contain privileged and confidential information. It is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby notified that any review, dissemination, distribution or duplication of this communication is strictly prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Fwd: Help 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 Daisley wrote: > 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 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 > Sent: Friday, September 04, 2009 3:39 PM > To: mysql@lists.mysql.com > Subject: Fwd: Help with Timestamp invalid value error > > 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 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. >> >> >> > > > [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
RE: Fwd: Help with Timestamp invalid value error
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 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 Sent: Friday, September 04, 2009 3:39 PM To: mysql@lists.mysql.com Subject: Fwd: Help with Timestamp invalid value error 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 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. > > > [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
