Wednesday, April 16, 2008

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

 

 

3 comments:

Anonymous said...

I would like to exchange links with your site improve-it.blogspot.com
Is this possible?

Anonymous said...

Найти лучшее: [url=http://filert.ugu.pl/syuv.html]image recovery скачать[/url]

Anonymous said...

Найти лучшее: [url=http://downaw.ugu.pl/tuvg.html]где скачать microsoft office 7 crack[/url]

Google
If you think my website is useful, please donate, contribute, ask question, & discussion can be addressed by contacting me at dcputranto et yahoo dot com. Thanks to .. unique person coming..
Feel know more.. To keep my research continue and provide better review/assessment and knowledge, feel free to donate by clicking button below....