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

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 24 May 2005 15:00:03 +0200
Message-ID: <d6v8gk$7uv$1@news.BelWue.DE>

Noons wrote:
> Holger Baer wrote:
>

>>>>4. Is this a bug I need to report ?

>
>
> would anyone care? ;)

I wasn't asking this, but your answer is certainly right :-)
>
>

>>Not according to the documentation (sql reference 9i):
>>
>>
>>DATE
>>
>>
>>Valid date range from January 1, 4712 BC to December 31, 9999 AD
>>

>
>
> Amazing! That's what I call future-proofing a product!
> :D
>

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) ;-)

Cheers
Holger Received on Tue May 24 2005 - 08:00:03 CDT