Bug #35815 Error 1292 when inserting particular date into timestamp field

• Submitted: 3 Apr 2008 20:14
• Modified: 3 Apr 2008 23:41
• Reporter: Peter Fer
• Status: Duplicate
• Category: MySQL Server: DML
• Severity: S2 (Serious)
• Version: 5.0.51a
• OS: Windows ( 5.0.51a-community-nt)
• CPU Architecture: Any
• Tags: timestamp

[3 Apr 2008 20:14] Peter Fer

Description:
When inserting timestamp value: '2008-03-30 02:00:00' into timestamp field, the server raises error 1292 with the message:

ERROR 1292 (22007): Incorrect datetime value: '2008-03-30 02:00:00' for column '
col' at row 1

It's strange, because occurs only for the particular date and time: 2008-03-30 between 02:00:00 and 03:00:00.

How to repeat:
Create sample table:

mysql> create table test (col timestamp);
Query OK, 0 rows affected (0.22 sec)

Insert data causing error:

mysql> insert into test(col) values('2008-03-30 02:00:00');
ERROR 1292 (22007): Incorrect datetime value: '2008-03-30 02:00:00' for column '
col' at row 1

To compare insert data with time one-hour later:

mysql> insert into test(col) values('2008-03-30 03:00:00');
Query OK, 1 row affected (0.04 sec)

[3 Apr 2008 23:41] MySQL Verification Team

Thank you for the bug report. Duplicate of bug: http://bugs.mysql.com/bug.php?id=34135