between 0000-00-00 and 9999-99-99

---

cuma yahoo lagi ada update system besar2an.

jadi sistem database mereka lagi ke ganggu.

ignore aja.

bbrp hari lg beres kok.

 

tp anehnya, knp lama yaa.

:) 

apa sistemnya yahoo lg boong yaa..??

terdeteksi di  :

- mailing list yahoogroups.com

- mail yahoo.com

 

 

 

 

 

 

---

Yep, 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.

• 12 hours ago

Source(s):

http://www.jamesmaurer.com/between-0000-... 

 

 

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