MySQL Bugs: #2779: Problem with timestamps near 19700101000001

Bug #2779	Problem with timestamps near 19700101000001
Submitted:	13 Feb 2004 12:42	Modified:	16 Feb 2004 5:49
Reporter:	Olivier Bettens	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	MySQL Server	Severity:	S3 (Non-critical)
Version:	4.0.17	OS:	Linux (Linux (debian))
Assigned to:	Ramil Kalimullin	CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
When I assign a valor from 19700101000001 up to 19700101010000 to a TIMESTAMP(14) field, it's set to 00000000000000

How to repeat:
CREATE TABLE test (tst timestamp);
INSERT INTO test SET tst = 19700101000030;
SELECT tst FROM test;

Expected : 19700101000030, got 0000000000000...

Looks like it's not a bug.
Actual TIMESTAMP values depend on your timezone.
TIMESTAMP values cannot be earlier than 1970 or later than 2037.
Any date not within this range will revert to 0000-00-00.
Please check that 19700101000001 in your timezone is greater than 19700101000000 UTC.