RE: Timestamp problem in mysql5.0.18

2006-03-21 Thread Jason Teagle
e- > From: Ricardas.S [mailto:[EMAIL PROTECTED] > Sent: 21 March 2006 14:31 > To: [EMAIL PROTECTED] > Subject: Re: Timestamp problem in mysql5.0.18 > > > Yes, I think you are right, it should be the main reason of > insert failure. > Thank you for good idea. > > Ricka &

Timestamp problem in mysql5.0.18

2006-03-21 Thread Ricardas.S
Hi All, Today, I encountered problem when trying to insert '2006-03-26 03:00:00' value into timestamp column: CREATE TABLE `test` ( `a` timestamp ) ENGINE = InnoDB DEFAULT CHARSET = latin1 COLLATE = latin1_german1_ci; INSERT INTO test VALUES ('2006-03-26 03:00:00' ); Server response was: ERROR