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

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Tue, 24 May 2005 20:37:52 +0200
Message-ID: <d6vs1a$pnc$1@news2.zwoll1.ov.home.nl>

> 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.

-- 
Regards,
Frank van Bortel

Received on Tue May 24 2005 - 13:37:52 CDT