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 1292 (22007) at line 4: Incorrect datetime value: '2006-03-26 03:00:00'
for column 'a' at row 1
All other date or hour values I tried, works good, but this one
is not accepted. UPDATE statement behaves the same.
Server time zone is GMT+2.
I tried 5.0.18nt and two linux versions, result is the same.
I tried to change time zone, and noticed that mysql server does not accept
2006-03-26 date with hour values which are equals GMT
offset + 1.
When I tried with ALLOW_INVALID_DATES option enabled, then server simply
changes hour upward to 04.
Is it mysql bug?
Ricka
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
