between 0000-00-00 and 9999-99-99 Yahoo Mail

If you have a Yahoo email account, you may notice between 0000-00-00 and 9999-99-99 at the bottom of the message. It’s a bug and usually happens during an upgrade and MySQL. It happens because Field_datetime:save_in_field() is reporting a failure because the data data is invalid. Convert_constant_item() will not function correctly and results in a comparison of the ‘dt’ field against binary string ’9999-99-99 etc’ rather than the datetime of ’0000-00-00 00:00:00′.

Long story short, you end up with between 0000-00-00 and 9999-99-99 which defines dates and indicates the start of the creation until the end of the time. For those that care, here are date details.

0000-00-00 – Special value used by programmers
AD 1 – Start of Christian Era (Roman Year 753)
1325 – Aztec Calendar
1582 – Gregorian Calendar (Solar- 400th year not leap)
1582-10-15 – Lilian Day 1
1752 – British Government (including American colonies) adapt Gregorian calendar
adopts Gregorian Calendar
1900 – Start of IBM/360 64 bit clock
1901-01-01 – Start of Lotus/Spreadsheet world
1904 – Start of original Apple Mac clock
1918 – Soviet Union adopts Gregorian Calendar
1920 – Current Start of Apple Mac World
1949 – Communist China adopts Gregorian Calendar
1960 – IBM/360
1966 – Elysia/933
1970 – IBM/370
1971 – IBM Clock rollover
1972-08-16 – 9999 days to 2000 (OS catalog corrupts)
1979-02-01 – Interface Age, Bob Bemer article
1980 – IBM 4300
1980-08-01 – MS DOS Default startup date (Zero date)
1986-06-30 – Deadline 2000 starts
1986-07-21 – Deadline 2000 ends
1986 – ANSI X3.30 defines YYYYMMDD standard
1987 – MVS SVC11 changes
VM IPL 01/01/00 to 2000
1988-07-30 – FIPS 4-1 YYYY standard in effect
1988 – ISO 8601 defines YYYY-MM-DD standard (but also allows 2 digit forms)
1991 – Chris Anderson writes about 4 digit years in MSDOS
1995 – Peter de Jager – Datamation
www.year2000.com on the air
US Congress Technical Committee
IBM announces Year 2000 ready ESA
1996-01-01 – UNISYS 8bit clock rollover
Datamation Year 2000 issue
1996 – US Congress subcommittees
1996-11-06 – comp.software.year-2000 begins
1996-11-15 – First “More Y2k Links” report
1996-11-19 – www.cinderella.co.za on the air
1996-12-13 – IBM announces VSE/ESA2.2 Y2k ready
1997-01-01 – Datamation Year 2000 issue
1997-03-18 – New York Stock Exchange trades on de Jager Index
1997-04-07 – 999 days to 2000 (catalogs?)
1997-10 – US Government Progress Reviews
1998-08-19 – Global Y2k Awareness Day
1998-12 – US Government deadline for Mission Critical apps
1999-01-01 – US Government deadline
1999-02-26 – SA Government Gazette on local government
1999-08-21 – GPS EOW 10bit counter rollover
99-09-09 – Special value used by programmers
1999-12-31 – PC BIOS Tickover problem:
Set the clock early!
Public Holiday in South Africa
Party Time
99/365 – End of Pseudo Julian world
99-99-99 – Special Value used by programmers
2000-01-01 – Last year of the 20th Century
Overflow of 2 digit years causes Meltdown?
2000-01-03 – Public Holiday in South Africa
2000-1-10 – First 9-character date
2000-02-29 – Leap Year
2000-10-10 – First 10 character date
2000-12-31 – 366th day of 2000
2001-01-01 – Start of 21st Century
2001-01-01 – Overflow Tandem Systems
2001-09-08 – Unix date 999,999,999
2006-08-08 – JC 350 Overclock
2010-01-01 – Overflow ANSI C library
2019 – Original Apple Mac end of world
2034-09-30 – Overflow Unix time function
2038-01-19 – UNIX signed 32bit timer rolls over
2040 – Current Apple Mac end of world
2042-09-18 – IBM 64bit clocks rolls over
2099 – MSDOS x86 (FAT 7 bit year) end of world
2100-01-01 – Not a leap year
2101-01-01 – Start of 22nd Century
3000-01-01 – Not a leap year
9999-99-99 – Special value used by programmers