Re: Question on the date after '31-DEC-9999' in Oracle

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Wed, 25 May 2005 09:56:17 +0200
Message-ID: <d71b32$qlr$1@news.BelWue.DE>

Frank van Bortel wrote:
>>It's even history-proof, what with all that kinky calendar
>>corrections during the last 2000 years, e.g
>>
>>
>>SQL> select to_date ('06.10.1582', 'dd.mm.yyyy') whats_that from dual;
>>
>>WHATS_THAT
>>----------
>>15.10.1582
>>
>>As you recall, after Oct 4th 1582 the next day was Oct 15th (I'm not
>>suggesting personal experience here) ;-)
>>

> 
> 
> Only in certain parts of the world... DB2, for one, uses another
> algorithm, which is equally valid, but just with different results.

Huh? The Julian Calendar ended on Oct 4th and the Gregorian Calendar started the very next day with Oct 15th 1582, although it took quite a while to catch on outside Italy, Spain, Portugal, Poland, especially in non-catholic countries.

http://en.wikipedia.org/wiki/Gregorian_calendar

Or are you saying, that DB2 does take the regional settings into account? That'd be another thing, but then it would, apparently without saying, change the underlying calendar.

What am I missing?

Holger Received on Wed May 25 2005 - 02:56:17 CDT