Oracle-L: Re: year 2059 problem

From: Nicolai Tufar <ntufar_at_apb.com.tr>
Date: Mon, 30 Dec 2002 04:56:21 -0800
Message-ID: <F001.0052414C.20021230045621@fatcity.com>

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.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Nicolai Tufar
INET: ntufar_at_apb.com.tr

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Dec 30 2002 - 06:56:21 CST