Re: year 2059 problem

[Nicolai Tufar]

UNIX stores time as amount of seconds passed since the 1st of January 1970. Since it is 32-bit value in modern Unices, it can hold up to 2,147,483,648  or approximatively 68 years. The counter overflows on 19th of January 2038 at 3:14:07 AM. People believe that all the hardware will be 64-bit by that time. But apparently it is not the case in Nepal.   Oracle, internally can handle dates well beyond that. It is definitely W2K's deficiency. Any other 32-bit platform will have it too. Looks like the only solution is to move to a 64-bit platform/OS.   For more information see: http://www.gsp.com/2038/   Hope it helps.   Nic.   ----- Original Message ----- From: Amit Nargotra To: Multiple recipients of list ORACLE-L Sent: Monday, December 30, 2002 6:28 AM Subject: year 2059 problem This strange problem we are facing while implemting Oracle Based ERP at Nepal for asian paints. Nepal follows Hindu calender, as per the hindu calender the current year is 2059. as we try to install oracle 9i keeping year as 2059. oracle gets installed, but it is unable to create database.(OS is windows - 2000 server) even D2K is not running on 2059. we have tried different years and we found that till 2035 oracle is able to create database after 2035 it fails to create database. we have contacted oracle india also. they have said this is windows related problem. can any body help us out.   Thanks in advance.